Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Calculating Values in DAX using a parameter

Hello!    I have recently been struggling to using a paramter in caluclations in DAX. Currently I have been attempting to use a parameter for a user to input the years of interest. After determinin...
Need Help
  • v-xicai's avatar
    v-xicai
    7 years ago

    Hi  Anonymous ,

     

    What if parameter can only be used in measure instead of calculated column, so you can create measure like DAX below.

     

    Identifier Column = if(MAX(Table4[Years]) = [measure],1,0)

     

    You can learn more:https://docs.microsoft.com/en-us/power-bi/desktop-what-if.

     

    Best Regards,

    Amy

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-xicai's avatar
v-xicai
Community Support
7 years ago

Hi  Anonymous ,

 

What if parameter can only be used in measure instead of calculated column, so you can create measure like DAX below.

 

Identifier Column = if(MAX(Table4[Years]) = [measure],1,0)

 

You can learn more:https://docs.microsoft.com/en-us/power-bi/desktop-what-if.

 

Best Regards,

Amy

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Gosh this seems so simple when you explain it that way but thank you so much! That worked perfectly! 

 

Austin I