Forum Discussion

AnetaK's avatar
AnetaK
Helper V
8 years ago
Solved

IF on date - Expressions that yield variant data-type...

Hello,   I have four status dates and want to show on the report always the latest status with the possibility to change to other dates. So I want to have "Last status" and the other dates. Somet...
Need Help
  • AnetaK's avatar
    AnetaK
    8 years ago

    Ha! I've found the solution! :)

     

    Status date = If('Status date'[Status date_date]=maX('Status date'[Status date_date]);"Last status";format('Status date'[Status date_date];"YYYY-MM-DD"))

BeemsC's avatar
BeemsC
Resolver III
8 years ago

Yea, like i said. You were good on your way with the formula. But its not possible for both the dates and "Last date".
If you use something like :
Column2 = IF('Status date'[Status date]=MAX('Status date'[Status date]);"Last status";"Not last status")

Or alternatively, if you only want "Last status"
Column2 = IF('Status date'[Status date]=MAX('Status date'[Status date]);"Last status";"")

Then you just add column 2 to a slicer. And if your relationships are correct, it should work

AnetaK's avatar
AnetaK
Helper V
8 years ago

Ha! I've found the solution! :)

 

Status date = If('Status date'[Status date_date]=maX('Status date'[Status date_date]);"Last status";format('Status date'[Status date_date];"YYYY-MM-DD"))