Forum Discussion
How to return multiple measures
Tx(1-5) are Measures and the ADMTR:1 and ADMTR:2 is in another table.
I've tried your options and I get lots of errors on the DAX expression.
Please I'd need this help
Hi Anonymous,
You can open Query Editor, add a index column like below:
Then create a calculated column use Switch() function:
STATION = SWITCH([Index],1,Tx1 ,2,Tx2,3,Tx3,4,Tx4,5,Tx5)
Best Regards,
QiuyunYu