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)
