Forum Discussion

abdulmannan1991's avatar
abdulmannan1991
Helper II
6 years ago
Solved

Create a Column using values from Parameter

Hello, Please assist with the following challenge:   Task: I want to create a column in a custom table (Month 1 to 24) which should take values from a What-IF Parameter. Any change in Parameter sli...
Need Help
Tips and Tricks
Tutorial Requests
  • dax's avatar
    dax
    6 years ago

    Hi abdulmannan1991 , 

    Yes, as nandukrishnavs  mentioned, the slicer can't change calculated column dynamically, so you need to use measure to achieve this goal, you could try below measure

    total = IF(HASONEVALUE('Month table'[MONTH NAME]), SUM('MONTH'[MONTH]), SUM('MONTH'[MONTH])*24)

     

    Best Regards,
    Zoe Zhi

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