Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Calculated column from Power BI Desktop not working in Report Server

Hello

 

To get the latest data out of the fact, I made a calculated column in Power BI, which I can use to filter my page.

If I choose the value 1 for that filter, I will get the latest month with data in the fact.

 

When I copy this calculated column to Report Server, I get an error.
I tried using selectedvalue but then my filter never finds a match, so only returns 0 


Below my code and the error message (sorry, the formatting doesn't transfer for some reason)

 

MaxMonth =
VAR LastValue =
CALCULATE (
LASTNONBLANKVALUE (
VD_DATE[D_DATE_MONT_YYYYMM_NUMBER],
SELECTEDVALUE ( VD_DATE[D_DATE_MONT_YYYYMM_NUMBER] )
),
VF_HR_INDIV_MONTH
)
RETURN
if(LastValue = MIN(SELECTEDVALUE(VD_DATE[D_DATE_MONT_YYYYMM_NUMBER])),1,0)

 

2 Replies

  • Are you sure this is a measure in Power BI Desktop?  Smells more like a calculated column.

    • Anonymous's avatar
      Anonymous
      Not applicable

      Oops, indeed!