Remodeling data from excel (VeeamOne extract)

[Pingouin_Puni]

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 !

[Anonymous · Accepted 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.

[Pingouin_Puni]

Hello,
Thank you very much, work fine ! The fill down option was something I was not aware of.

Regards

[WishAskedSooner]

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.