Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.