show difference between tables

[Anonymous]

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 because I get stuck completely. I thought about conditional formatting but i dont know how and about creating an extra table where the file numbers are shown ( one table for files added and one table for files missing) but i dont know how. 

The visuals are made based on five different excel files that i put in a folder. these Excel files are all unloading schedules.

i hope some one understand me and can help.

Best regards

[Anonymous]

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

[v-alq-msft]

Hi, @Anonymous 

Based on your description, I think you use 'Edit Interaction' to filer the corresponding table visual. If so, you may be unable to dynamically do a left join between two table visuals with a direct way.

Best Regards

Allan

[Greg_Deckler]

It looks like you have used Edit Interations to setup your slicers so that they only affect each individual visual. The problem is that this works visually but if you create a measure for conditional formatting, it will have a devil of a time figuring out what is going on. I would recommend four date tables, Table 1: Created Date, Table 2: Updated Date, Table 3: Created Date, Table 4: Updated Date. You could link them to your table date table -> fact table. 

Then, you can use SELECTEDVALUE to grab the selected value from each of these tables (the value in your slicer). Now you should be able to use ALL to break out of filter context and see if a File that appears with the created date and updated date from tables 1 and 2 also appears when filtering by 3 and 4.

If you post sample data as text, I can be more specific.

[amitchandak]

Create two date table using the calendar. Use one as created that. The second one has upload date. Join them with both tables, Also create other dimensions like Planning.

Join them with both tables and analyze them together.

Refer: https://docs.microsoft.com/en-us/power-bi/guidance/star-schema

https://docs.microsoft.com/en-us/power-bi/guidance/

[tkirilov]

Hi there,

How do you distinguish between planning #1 and #2? From what I can see you only have one table in your dataset, called "Inbound planning".