Forum Discussion

frostys's avatar
frostys
Icon for Helper I rankHelper I
8 years ago

Change a value by a variable in measure

Hi everyone,   I try change this value ("3") by a variable :       EOMONTH('Data input'[Date],3)>TODAY() I want to choose with a slicer the number of month. I have created a new table "Time sl...
Need Help
frostys's avatar
frostys
Icon for Helper I rankHelper I
8 years ago

Maybe the solution working, but not for me. Could be a different problem. So I can't tell if this is the right formula yet.

v-jiascu-msft's avatar
v-jiascu-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi frostys,

 

Can you share a dummy sample of your data? Please try the demo in the attachment.

Selected time =
VAR selected =
    SELECTEDVALUE ( 'Time slicer'[Time slicer] )
RETURN
    IF ( ISBLANK ( selected ), 0, selected )

3

 

Best Regards,

Dale