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
Featured Session Drive Data Culture with Power BI: Vision, Strategy & Roadmap. Register here https://myignite.microsoft.com #MSIgnite #PowerPlatform #Power BI
Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!
User | Count |
---|---|
445 | |
186 | |
109 | |
60 | |
51 |
User | Count |
---|---|
436 | |
180 | |
122 | |
76 | |
74 |