Forum Discussion
Mp1977
Helper II
Helper IIDynamically change a column in a measure
hi ! I have a table with 3 columns: Date, Sales and Cost. I need to create the measures for sales and cost. in fact, too many of them. My question is possible to dynamically change a column ...
You'll need to use the SWITCH approach with a disconnected table, or a better way is to use a calculation group.
Pat
mahoneypat
Microsoft Employee
Microsoft EmployeeYou'll need to use the SWITCH approach with a disconnected table, or a better way is to use a calculation group.
Pat
Mp1977Helper II
Helper IIThank you very much.
Switch requeires to create all the measures.
I will check the calclation group .
Hey, did you find a solution. Did it work?