MROUND

[Anonymous]

Hi all 😁,

In scope of my project i created a what if parameter and i got a new table (lets say table A) with a column( which contains the values that i chose and a measure that keeps the value, which will be chosen by the user.

I also have an other table from the data that i imported (lets say table B)

The next step that i want to do, is to create a new column in my table B using the function MROUND  like this :

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

As it is obvious i can not do this beacause one argument is a column and the other is a measure.So the question is:

HOW CAN I DYNAMICALLY  ROUND THE VALUES OF A COLUMN BY A VALUE WHICH IS CHOSEN BY THE USER???

Thank you in advance.

[v-juanli-msft · Accepted solution]

Hi @Anonymous 

Create a measure,[Parameter Value] is a measure

Measure = MROUND(MAX(TableB[Column1]),[Parameter Value])

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

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