Calculating differences between multiple columns and then the median of these values

Question

HiI have been asked to calculate the following three stage exercise:Calculate the differences between the weekly data in the table below&nbsp;Calculate the median of those weekly differences for a specific weekCalculate the movement in the median of weekly differences compared to the previous weekThe above is an ongoing exercise each week so I suspect use of variable will be necessary.&nbsp;&nbsp;Week 1Week 2Week 3Week 4Week 5Week 6Week 7Worms2345678Overcooked11234567435456The Survivalists34544345675456&nbsp;I appreciate I could just do the calculations in excel and upload the weekly differences but believe there will be a solution just in Power BI.&nbsp;&nbsp;

allisonkennedy · Accepted Answer

NickTeam17I suggest you unpivot this data, which is done in the Power Query Editor. So to make it as dynamic as possible select all the columns that are NOT weeks, then select Unpivot Other Columns.. Then you will have two columns: Attribute and Value. Rename Attribute to Week Number and Value to whatever you want.When you've got that under control, come back and see us if you need more help with calculating the average, difference and filtering by week, but this will be more straightforward once it's in columns.https://radacad.com/pivot-and-unpivot-with-power-bi

Forum Discussion

Calculating differences between multiple columns and then the median of these values

2 Replies

Related content

Dynamic Calculation Different Period

Different Calculations

Using Visual Calculation on a Calculated Group with Multiple Calculated Items

CALCULATE with multiple filters

1. How to add two different calculated columns of two different table

	Week 1	Week 2	Week 3	Week 4	Week 5	Week 6	Week 7
Worms	2	3	4	5	6	7	8
Overcooked	11	23	45	67	43	54	56
The Survivalists	34	54	43	45	67	54	56