Help - Power Query

Power Query
1

Hi everyone,

I just received an Excel file to create a Power BI project but I’m a bit confused about the first steps in Power Query.
As you can see there are 3 equipment with their own tag at the same worksheet. I’ll receive one file everyday and it’ll be at the same structure.

I’m trying to create a table with one column as a date time and the other with all the related information. Can anyone help me?

Examples.xls (51 KB)

3

Hi,

If i understand you requirement correctly you want the below result:

image
image879×545 11.9 KB

I have attached the pbix file which conation the above solution .

In case this is not the req result pls let me know i try to help you to achieve that.

Report.pbix (283.7 KB)

Thanks

2 Likes
4

Thank you so much!!! It’s working!

5

Its grt pls mark the above post as solution to close this thread.

Thanks