Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I'm looking for advice on how I could split the follwoing rows which display my target and my actuals into columns, essentially reducing on rows and increading my columns.
This is what I have
This is what I need to achive.
Note, I have a number of columns, not just 1, I've just reduced and simplifted to create this example.
Date | Column4 | Column 1 |
01 May 2020 | Target | 36 |
01 May 2020 | Actual | 38 |
01 June 2020 | Target | 60 |
01 June 2020 | Actual | 51 |
01 July 2020 | Target | 0 |
01 July 2020 | Actual | 0 |
01 September 2020 | Target | 40 |
01 September 2020 | Actual | 35 |
01 October 2020 | Target | 60 |
01 October 2020 | Actual | 78 |
01 November 2020 | Target | 0 |
01 November 2020 | Actual | 0 |
01 December 2020 | Target | 0 |
01 December 2020 | Actual | 0 |
Solved! Go to Solution.
Use the "Pivot" operation in Power Query. It's a one-click operation.
Use the "Pivot" operation in Power Query. It's a one-click operation.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
49 | |
27 | |
20 | |
15 | |
12 |
User | Count |
---|---|
58 | |
50 | |
44 | |
19 | |
18 |