Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I am very new to Power BI, need your advice.
I would like to compare one column (e.g. Performance KPI) but from different date range e.g. Pre and Post
Pre selection dates -Filter (slicer)
Post selection dates - Filter (slicer)
Performance KPI = AVERAGE(PerformanceKPI)
example of data
Date PerformanceKPI
1/1/2020 10
1/2/2020 9
1/3/2020 8
..
5/1/2020 10
5/2/2020 10
I try to duplicate date to post date, and use slicer but it did not work since pre date and post date is the same date.
Try to use calculate but cannot make it work, please advise.
Thank you very much
Solved! Go to Solution.
hi @getitout
You could refer to this blog:
Filtering and comparing different time periods with Power BI
Regards,
Lin
hi @getitout
You could refer to this blog:
Filtering and comparing different time periods with Power BI
Regards,
Lin
Can you check, if this can help :https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601
The information you have provided is not making the problem clear to me. Can you please explain with an example.
Appreciate your Kudos.
Thank you very much. Will try and let you know.
Hi,
Please be very clear in telling us what exactly would you be selecting in the Date slicers - will it be a single date or a range of dates? Why do you need two slicers - why not just one? Take a clear example and show the expected result.
There will be 2 slices since we want to select pre dates (range) and post date range, which is not overlapped.
Thanks for the comment, this is my first post. Will try to write clearer.
Hi,
I still do not understand. I am willing to help if you take a clear example and show the exact expected result.
Thanks for all the suggestion.
I've got the solution from the community to use cross join
User | Count |
---|---|
90 | |
74 | |
67 | |
63 | |
55 |
User | Count |
---|---|
101 | |
92 | |
74 | |
60 | |
59 |