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
v-jiascu-msft's avatar
v-jiascu-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi frostys,

 

Did you solve it? Can you share the answer or mark the proper answer as a solution please?

 

Best Regards,
Dale

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

Hi v-jiascu-msft,

 

I didn't find the solution yet

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

    Hi frostys,

     

    Isn't that formula a solution even if it can work? Can you share a dummy file? To be honest, your scenario isn't  complicated.

     

    Best Regards,

    Dale

    • 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