Comparison report

Question

&nbsp;Hi Guys&nbsp;I am trying to create&nbsp; version comparison report in&nbsp; country table based on load date .I would like to have filters like&nbsp; Loaddate source , Loaddate to be compared and Country filter&nbsp;Only input is Country table lok below&nbsp;&nbsp;Cid&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Cname&nbsp; &nbsp; CountryDesc&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Loaddate&nbsp;1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;India&nbsp; &nbsp; &nbsp; &nbsp; Bharath India&nbsp; &nbsp; &nbsp; &nbsp; 01-04-20201&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;India&nbsp; &nbsp; &nbsp; &nbsp; India&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;20-04-2020&nbsp;&nbsp;My report should be&nbsp;Loaddate source (01-04-2020 )&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Load date to compared&nbsp; (20-04-2020)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Country (India ) *optional filter&nbsp;&nbsp;Source report&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Comparison report&nbsp;Cid&nbsp; Cname&nbsp; &nbsp; Cdesc&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Loaddate&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Cid&nbsp; &nbsp;Cname&nbsp; &nbsp; Cdesc&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Loaddate&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Status&nbsp;1&nbsp; &nbsp; &nbsp; India&nbsp; &nbsp; &nbsp; Bharath India&nbsp; &nbsp; 01-04-2020&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; India&nbsp; &nbsp; &nbsp; &nbsp; India&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 20-04-2020&nbsp; &nbsp; &nbsp;Changes available&nbsp;&nbsp;So here in the Comparison report it has lookup with source report on&nbsp;&nbsp;Cid&nbsp; &nbsp;Cname&nbsp; &nbsp; Cdesc&nbsp; column .If source and compare table&nbsp;&nbsp;Cid&nbsp; &nbsp;Cname&nbsp; &nbsp; Cdesc&nbsp; values are same then " No changes " else " Chanes avaiable "&nbsp;&nbsp;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 .&nbsp;Could you anyone help me on this ?&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

amitchandak · Answer

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
&nbsp;
How to use two Date/Period slicers: https://youtu.be/WSeZr_-MiTg

anonymous · Answer

amitchandak&nbsp; , 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&nbsp;&nbsp;&nbsp;Cid&nbsp; &nbsp;Cname&nbsp; &nbsp; Cdesc&nbsp;&nbsp; . For my case also i created 2 independent date . Hope i have shared enugh of information

anonymous · Answer

amitchandak&nbsp; &nbsp;Reuirement is dirct , business wants to compare country details change based on version date .&nbsp;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

anonymous · Answer

HI Team ,&nbsp;Could you anyone help me here to fix this issue , i am struggling for long period&nbsp;attached my sample expected report here&nbsp;&nbsp;Left side&nbsp; : Sample country table data :&nbsp; &nbsp;&nbsp;After yellow remark expected 2 table visual&nbsp;&nbsp;&nbsp;

ashish_mathur · Answer

Hi,
Sorry but cannot understand your question at all.

Forum Discussion

Comparison report

5 Replies

Related content

Comparison Chart

BI Tools Comparison

Comparison Table

Comparison matrix table

PBIX reports comparison