Forum Discussion
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.
HI Anonymous,
Nope, current you can't create dynamic calculate column/table based filter/slicer.
For measure formulas, they are expressions that calculates based on aggregated row contents. ( its row contents will be fixed when you try ot use it in a calculated column and not interact with filters)
Regards,Xiaoxin Sheng
1 Reply
HI Anonymous,
Nope, current you can't create dynamic calculate column/table based filter/slicer.
For measure formulas, they are expressions that calculates based on aggregated row contents. ( its row contents will be fixed when you try ot use it in a calculated column and not interact with filters)
Regards,Xiaoxin Sheng