Comparison report

[Anonymous]

 Hi Guys

I am trying to create  version comparison report in  country table based on load date .

I would like to have filters like  Loaddate source , Loaddate to be compared and Country filter 

Only input is Country table lok below 

Cid           Cname    CountryDesc          Loaddate 

1                 India        Bharath India        01-04-2020

1                 India        India                     20-04-2020 

My report should be 

Loaddate source (01-04-2020 )                    Load date to compared  (20-04-2020)         Country (India ) *optional filter 

Source report                                                           Comparison report 

Cid  Cname    Cdesc                Loaddate                   Cid   Cname    Cdesc            Loaddate         Status 

1      India      Bharath India    01-04-2020                1      India        India              20-04-2020     Changes available 

So here in the Comparison report it has lookup with source report on  Cid   Cname    Cdesc  column .

If source and compare table  Cid   Cname    Cdesc  values are same then " No changes " else " Chanes avaiable " 

I have tried with natual join by giving seleted date filter slicer value to source table , but it seems we can't derive table dynamically by giving selected slicer value as input .

Could you anyone help me on this ?

[amitchandak]

@Anonymous , Not very clear. But this blog and video of mine can help

https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601

How to use two Date/Period slicers: https://youtu.be/WSeZr_-MiTg

[Anonymous]

HI Team ,

Could you anyone help me here to fix this issue , i am struggling for long period

attached my sample expected report here 

Left side  : Sample country table data :   

After yellow remark expected 2 table visual 

[Ashish_Mathur]

Hi,

Sorry but cannot understand your question at all.

[Anonymous]

@amitchandak  , Thanks for your help . In your post comparing only sales amount data , but for me i have to compare both source and compare table on each column basis like mentioned above   Cid   Cname    Cdesc   . For my case also i created 2 independent date . Hope i have shared enugh of information

[Anonymous]

@amitchandak   Reuirement is dirct , business wants to compare country details change based on version date . 

Sometime country name may or country code or country desc like that , So selected period the data has to be compared on this 3 columns