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.
Hi All,
I am importing data from a sharepoint excel and running a python script to expand and maniplate the table into the required format. This works excellently but I have found out that python only supports personal gateway. It is a requirement that we can refresh this report with cloud gateway. Therefore I believe my only option is to recreate what my python script was doing in power bi (which I am less familiar with).
In essence what I am trying to do is as follows:
Input table (sharepoint):
Effort | ||||
Prefix | 2020 Q1 | 2020 Q2 | 2020 Q3 | 2020 Q4 |
proj1 | 10 | 14 | 13 | 12 |
proj2 | 2 | 6 | 10 | 12 |
Should expand to:
Date | Prefix | Effort |
01/01/2020 | proj1 | 10 |
01/01/2020 | proj2 | 2 |
02/01/2020 | proj1 | 10 |
02/01/2020 | proj2 | 2 |
.. | .. | .. |
.. | .. | .. |
31/12/2020 | proj1 | 12 |
31/12/2020 | proj2 | 12 |
I want to take a simple table with effort per project for each quarter and expand it out to each day of the year and for each prefix.
What would be the 'power bi way' to approach this problem? My guess is that I am going to have to learn some M and tackle this in the advanced editor. Any material or examples is welcome!
Your expert advise would be appreciated!
Olly
@owallis , Can Transpose help: https://yodalearning.com/tutorials/power-query-helps-transposing-data/
https://radacad.com/pivot-and-unpivot-with-power-bi
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 |
---|---|
12 | |
2 | |
2 | |
1 | |
1 |