Calculated column from Power BI Desktop not working in Report Server

Anonymous — Mon, 17 Jul 2023 06:10:05 GMT

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)

Re: Calculated column from Power BI Desktop not working in Report Server

lbendlin — Sun, 16 Jul 2023 22:48:11 GMT

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

Re: Calculated column from Power BI Desktop not working in Report Server

Anonymous — Mon, 17 Jul 2023 06:10:48 GMT

Oops, indeed!

topic Calculated column from Power BI Desktop not working in Report Server in Report Server

Calculated column from Power BI Desktop not working in Report Server

Re: Calculated column from Power BI Desktop not working in Report Server

Re: Calculated column from Power BI Desktop not working in Report Server