Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 ?
@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
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
Hi,
Sorry but cannot understand your question at all.
@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
@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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
99 | |
73 | |
72 | |
49 |
User | Count |
---|---|
145 | |
109 | |
108 | |
90 | |
64 |