Welcome to deBUG.to Community where you can ask questions and receive answers from Microsoft MVPs and other experts in our community.
Ask a Question

FIRSTNONBLANK in DirectQuery Power BI

0 like 0 dislike
2.2k views
in Power BI by ●26 ●30 ●36

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

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


1 Answer

1 like 0 dislike
by ●163 ●204 ●403
selected by
 
Best answer

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

deBUG Community deBUG.to
If you don’t ask, the answer is always NO!
...