Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello!,
I don't know if this is possible, but is there a way to copy a measure value in a column? i have two measures, one is x measure and the other is x rolling average measure, i want to be able to filter them in a column chart but, to do that, i know that i should need a column "type of measure" . This is what i have:
year | month | x measure | x rolling average |
2017 | enero | 71% | 71% |
2017 | febrero | 64% | 68% |
2017 | marzo | 72% | 69% |
2017 | abril | 72% | 70% |
2017 | mayo | 77% | 71% |
2017 | junio | 75% | 72% |
2017 | julio | 73% | 72% |
2017 | agosto | 76% | 73% |
2017 | septiembre | 68% | 72% |
2017 | octubre | 66% | 72% |
2017 | noviembre | 66% | 71% |
2017 | diciembre | 66% | 71% |
2018 | enero | 59% | 59% |
i expect to create a new table like this:
year | month | Value | type of measure |
2017 | enero | 71% | x measure |
2017 | enero | 71% | x rolling average |
2017 | febrero | 64% | x measure |
2017 | febrero | 68% | x rolling average |
2017 | marzo | 72% | x measure |
2017 | marzo | 69% | x rolling average |
2017 | abril | 72% | x measure |
2017 | abril | 70% | x rolling average |
2017 | mayo | 77% | x measure |
2017 | mayo | 71% | x rolling average |
2017 | junio | 75% | x measure |
2017 | junio | 72% | x rolling average |
i know if i copy the measures formulas to the Value column i wont get the same result, i want the value of the measures to be in one column (without being altered) and distinct them based on a another "type of measue" column.
Thanks!
You may create a calculated table first, then use IF Function to add a measure.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
94 | |
83 | |
67 | |
59 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |