Forum Discussion
Simple Table?
HI Anonymous,
After you are getting data to power side, you can do unpivoted column on these value fields(high, medium, low) to convert them to attribute and value. Then you can create a matrix with attribute as row , date field on column to reproduce these effects.
Unpivot columns - Power Query | Microsoft Learn
For add custom row to matrix, you may need to create a new table with raw row field value and new values.
Then you can use it on matrix row. You need to write a measure formula to use on value field to use current row context value to lookup row label value and reduce to different calculation formula.
Regards,
Xiaoxin Sheng
HI Anonymous,
After you are getting data to power side, you can do unpivoted column on these value fields(high, medium, low) to convert them to attribute and value. Then you can create a matrix with attribute as row , date field on column to reproduce these effects.
Unpivot columns - Power Query | Microsoft Learn
For add custom row to matrix, you may need to create a new table with raw row field value and new values.
Then you can use it on matrix row. You need to write a measure formula to use on value field to use current row context value to lookup row label value and reduce to different calculation formula.
Regards,
Xiaoxin Sheng