Forum Discussion

vickyprudhvi's avatar
vickyprudhvi
Helper IV
10 years ago

Error in PowerBI Deskopt using LastDate function

Hi Friends, I am using lastdate function in my tabular model. Following is my measure SUMX(VALUES(ClaimRoot[Claim Number]),                                            CALCULATE(  SUM(ClaimRoot[Th...
Need Help
v-sihou-msft's avatar
v-sihou-msft
Microsoft Employee
10 years ago

Hi vickyprudhvi,

 

In DAX, when adding filters in CALCULATE() function, it must be either a boolean expression or a table expression that defines a filter. And the LASTDATE() returns a table containing a single column and single row with a date value. So the syntax of your DAX is correct. In this scenario, you need to check if there are duplicated rows in Cl​aimRoot[EffectiveTimestamp] column as the error message mentioned.

 

Regards,