FIRSTNONBLANK in DirectQuery Power BI

Question

In Power BI directQuery mode, Is it possible to use the FIRSTNONBLANK for a calculated column? 

Function placeholder is not allowed as part of calculated column dax expression on directquery models

Answer 1

Function placeholder is not allowed as part of calculated column DAX expression on DirectQuery models

In Power BI, this error refers to that the provided function is NOT supported for use in DirectQuery mode when used in Calculated Column.

So, in Power BI DirectQuery mode, the FIRSTNONBLANK is not supported to be used in a calculated column or Row-level security (RLS). however, you can use it for a Measure in DirectQuery mode without any issue.

FIRSTNONBLANK returns the first value in the column that is not a blank filtered by an expression.

Unsupported function in a calculated column in DirectQuery mode

below are some examples of functions that are unsupported for use in a calculated column in DirectQuery mode.

1. Min
2. Max
3. Sum
4. Average
5. Count

---

See Also

• Is there any tool to convert SQL query to DAX formula in Power BI?
• DAX function reference
• Quick Introduction to DAX in Power BI