MROUND

[Anonymous]

Hello everyone 😁 ,

In the scope of my project I created a what if parameter and got a new table (say 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 (say 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.

[amitchandak · Accepted solution]

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

[v-chuncz-msft · Accepted solution]

@Anonymous 

By the way, you may take a look at the post below to learn more.

https://community.powerbi.com/t5/Desktop/How-do-I-Call-a-Power-Query-M-Function-from-a-DAX-Measure/m...

[amitchandak · Accepted solution]

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