Forum Discussion
MROUND
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.
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.
2 Replies
Anonymous ,You have to create a measure. You can not create a dynamic column using a measure or whatif
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.
