Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I was trying to figure out a way to filter by company when the weekly totals are returned on 1 row by week.
Example of returned row from database:
| WeekEnding | Company1 | Company2 | 2019-07-27 2500 3500 2019-07-20 2200 3350 2019-07-13 2600 3450
It was easy to combine the totals by week using a measure and SUM to combine both totals. But is it possible to have a filter where the TOTAL will be updated depending on if Company1 or Company2 or Both is selected?
Solved! Go to Solution.
@sharmon9000 - When more than one column are essentially the same data, it is best to "Unpivot" the columns. The easiest way to unpivot columns is in Power Query. Click "Edit Queries" to open the Power Query Editor, and then do the following:
1. Select Transform tab.
2. Select "WeekEnding" column.
3. Click the arrow next to"Unpivot Columns".
4. Click "Unpivot Other Columns".
@sharmon9000 - When more than one column are essentially the same data, it is best to "Unpivot" the columns. The easiest way to unpivot columns is in Power Query. Click "Edit Queries" to open the Power Query Editor, and then do the following:
1. Select Transform tab.
2. Select "WeekEnding" column.
3. Click the arrow next to"Unpivot Columns".
4. Click "Unpivot Other Columns".
User | Count |
---|---|
90 | |
74 | |
67 | |
63 | |
55 |
User | Count |
---|---|
102 | |
93 | |
73 | |
60 | |
59 |