Forum Discussion

sarikei's avatar
sarikei
Icon for Helper I rankHelper I
3 years ago

Selection from Slicer

Hi,   I have a Slicer defined in my report, it displays a list of predefine Date. i.e. This Month, Last Month, This Year, Last Year. I want to create the Measure to check if the selected value is...
Need Help
MAwwad's avatar
MAwwad
Icon for Solution Sage rankSolution Sage
3 years ago

Hello,

 

Logic as : If the value selected is = "This Month" then return 1 

                Else Return 0

Try this:  If(Value(Date) = "This Month",1, If(Value(Date) = "This Year",2,etc.....

 

Or you can use SWITCH Case

 

Dont forget to accept this as a solution if it helped you 🙂