Forum Discussion
show difference between tables
Dear power bi specialist, I want powerbi to compare the two visuals made and to show which files are in visual planning # 2 and not in planning # 1 and vice versa what is the best way to do this ...
Hi Greg_Deckler amitchandak tkirilov v-alq-msft ,
Thank you all for the quick replies and feedback. Because the data was not structured, I changed the data structure (for the better I hope). I went and created two tables. The 'Folder data' is where the information of my excel files is stored. And 'Inbound planning' is the data that is stored in the individual excel files. I made a relationsship with these tables based on the 'name' and 'source.name'.
I think it will be easiers making a measure or a comparison this way.
But my question remains the same. Could you guys please advise ?
Grts,
Kenneth