Forum Discussion
Solved
If function to return values in measure based on Slicer selection
Hi all, I have been looking for a solution all day long on the forum, but could find one that worked for me. I have two columns Fiscal Year and Buget ref as seen in the screenshot. Fiscal year i...
rischav, Try a new measure like
Budget year classification = if(max(Table[Fiscal Year]) = max(Table[Budget Ref]) ,"PY","CY")
amitchandak
Super User
Super Userrischav, Try a new measure like
Budget year classification = if(max(Table[Fiscal Year]) = max(Table[Budget Ref]) ,"PY","CY")