Forum Discussion

lastnn30's avatar
lastnn30
Post Patron
4 years ago

data modling 3 files.

Hi

I downloaded this example from the internet (please see the link below). The author I think did the merge using power bi data model. I am not sure how the author managed to do that in one table. Please see the next 2 screenshot. I tried to do the data modling 

 

I tried to do the data modling but I got different modling, please see the pic below

 

The excel source files and the pbi file are here:

https://drive.google.com/drive/folders/1ChLRSjbzKuk7LioiJUWcAVSypMVmiyWg?usp=sharing

Need Help

1 Reply

  • jdbuchanan71's avatar
    jdbuchanan71
    Super User
    4 years ago

    If you right click on the 2012 table in the .pbix file you can go to 'Edit Query' and see all the transofrmations the user applied to the files.