Forum Discussion

hellojb's avatar
hellojb
Frequent Visitor
3 years ago

Pivot Measures

I created 5 measure that calculates the current count and projection of status A, B, and C. 

StatusCurrentQ1 2023Q1 2023Q1 2023Q1 2023
A250280300320350
B8085908892
C5040443010

 

I want to pivot the table so I can combine the measures in one table and create a line chart with the date in x axis and count in the y axis, and status as a legend.

StatusDateCount
A

Current

250
AQ1 2023280
AQ2 2023300
AQ3 2023320
AQ4 2023350
B

Current

80
BQ1 202385
BQ2 202390
BQ3 202388
BQ4 202392

 

I was able to create this table using summarizedcolumn but I need to apply filters and dynamically update the table so I need to create a measure that will allow me to pivot the measure to this view.