Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

MROUND

Hello everyone 😁,

In the scope of my project I created a what if parameter and got a new table (for example, table A)with a column (containing the values I chose and a measure that maintains the value, which will be chosen by the user.

I also have another table of the data I imported (for example, table B)

The next step I want to do is to create a new column in my table B using the MROUND function in this way:

NEW COLUMN-MROUND(TableB[Column]; TableA[measure])

Obviously I can't do this because one argument is a column and the other is a measure. So the question is:

HOW CAN I DYNAMICALLY CHOOSE THE VALUES OF A COLUMN FOR A VALUE THAT IS CHOSEN BY THE USER???

Thank you in advance.

  • Anonymous , You have to create a measure. You can not create a dynamic column using a measure or whatif

3 Replies

  • mahoneypat's avatar
    mahoneypat
    Microsoft Employee

    Calculated columns only recalculate at refresh, so you should consider a measure instead.  If you need user input just on refresh, you could also consider a power query parameter.

     

    Regards,

    Pat

    • Anonymous's avatar
      Anonymous
      Not applicable

      Thanks a lot i will give it a try

       

  • Anonymous , You have to create a measure. You can not create a dynamic column using a measure or whatif