Forum Discussion
Remodeling data from excel (VeeamOne extract)
Hello !
I am trying to remodel in PowerBI an excel direct extract from a backup tool. Data is not presented in a way to make analysis easy.
The screeshot 1 is presenting raw data, the 2nd what I am aiming for. Basically, I need the backup job name not to be an independant line but to be linked with its bellow status.
Raw data
Screenshot 1_raw data
Goal :
Screenshot 2_goal
I am trying to do this with PowerBI, but would be happy even with an excel solution 😅
Would you have any pointers for me ? Thanks a lot !
Thank you WishAskedSooner
Hi, Pingouin_Puni
Based on your source data, I made a sample data as follows:
First, I will prepare the following table:
Perform a merge operation on Table1 in PowerQuery:
Finally, remove the rows where value is empty to get the output you expect:
How to Get Your Question Answered Quickly
If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .
Best Regards
Jianpeng Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
WishAskedSoonerContinued Contributor
This is a job for PowerQuery whether in Excel or PowerBI. Hard to say exactly what the PowerQuery M code would look like without an actual example or mock up of the data, but it shouldn't be too hard. Or, maybe a power user here can post a quick solution.
Thank you WishAskedSooner
Hi, Pingouin_Puni
Based on your source data, I made a sample data as follows:
First, I will prepare the following table:
Perform a merge operation on Table1 in PowerQuery:
Finally, remove the rows where value is empty to get the output you expect:
How to Get Your Question Answered Quickly
If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .
Best Regards
Jianpeng Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hello,
Thank you very much, work fine ! The fill down option was something I was not aware of.Regards
