Forum Discussion
Copy measures values in one column on another table
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!
2 Replies
v-chuncz-msftCommunity Support
please review https://www.microsoft.com/store/apps/9N60JMZCMCHC
