Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
I have different measures. for example
Measure 1 = X
Measure 2 = Y
Measure 3 = Z
How can I create a new table with 2 columns as follow:
name Value
M1 measure1
M2 measure2
M3 measure3
Thanks,
Create a new table usingt "Enter data" and make one column with M1, M2, M3 etc.
Then make a new column and use if statement for each value.
So If(Column1 = M1;Measure1;"") etc.
didnt actually test this.
Let me know if it works
negative. I cannot select the measure in the if statement.
Try create the measures with variables ? maybe it can work like that
What do you mean create with variables?
Hi @abukapsoun.
Can you please give us exactly what your measures compute with sample data and expected results and we will try to help.
Ninter
User | Count |
---|---|
141 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
123 | |
101 | |
71 | |
61 |