Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

LASTNONBLANK VALUE

Hello everyone, I am writing to you about a measurement query that I can't solve. Below is a table of yield calculation. I would like to be able to display in the column "Rend_N-1(%)" the la...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Thanks ERD  but I have the same error message : "A "FILTER" function was used in a True/False expression used as a table filter expression. This is not allowed." when I used the "filter" function ...

ERD's avatar
ERD
Icon for Community Champion rankCommunity Champion
5 years ago

Anonymous,
Just in case, please, update your PBI Desktop.

 

Rend_N-1 (%) measure = 
VAR currentDate = SELECTEDVALUE(dim_date[Date])
VAR previousDate = CALCULATE(
    MAX(dim_date[Date]),
    FILTER(
        ALLSELECTED(dim_date),
        dim_date[Date] < currentDate)
)
RETURN
MAXX(
    FILTER(
        ALLSELECTED(dim_date),
        dim_date[Date] = previousDate
    ),
    [Rend_dynamique (%)]
)