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
Thejeswar's avatar
Thejeswar
Icon for Super User rankSuper User
8 years ago

Hi frostys,

Try using the below code

 

 

EOMONTH('Data input'[Date],SELECTEDVALUE('Time slicer'[Time slicer])>TODAY()

 

Here the

SELECTEDVALUE('Time slicer'[Time slicer])

will hold the value of the selection that you make in the slicer 

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

    Hi Thejeswar,

     

    This syntax is incorrect ,

     

     

     

    I think it expect a alternate result but I don't find the correct syntax

    • Thejeswar's avatar
      Thejeswar
      Icon for Super User rankSuper User
      8 years ago

      Hi,

      DId you try my other suggestion?

      Did it work?

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

        Hi Thejeswar,

         

        Yes, it work only with the minimum value, "1". The other values selected with the slicer doesnt work

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

      Hi frostys,

       

      Regarding to syntax error, you missed a ")" before ">TODAY()".

       

      Best Regards,

      Dale