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,
So for example, I have
2 types of dates
Forecasted Date | Actual Date | Value |
1/2/20 | 1/2/20 | 1 |
3/2/20 | 2/2/20 | 2 |
3/2/20 | 4/2/20 | 3 |
I am creating a matrix table that shows the values according to the forecasted dates and the values shown are controlled by a toggle.
Toggle > 1. Forecasted date
2. Actual Date
Because all this data is in a single query, I am unable to create 2 relationships of dates to a single calendar table and the way I have done is thus far is to split the 2 dates into 2 different queries and linking them seperately to 1 calendar table.
However by doing so, I have to regroup filters which make it a hassle to do it twice, is there a more elegant way to do this based off 1 query?
Solved! Go to Solution.
@Anonymous , you can join them to the same date table and use userelation.
Refer my blog for example: https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970
Hi,
I found a video to solve the problem. by using DAX. It is well functionning for my reports.
https://www.youtube.com/watch?v=u8_aeLmXbVk
Hope it will be helpfull.
KR, Nathalie
Hi @Anonymous
You could unpivot the "Forecasted date" and "actual date" columns in Transform data, then you would get a column with "forecast date","actual date", then a column with dates.
Next, create a relationship between the dates above and your calendar table.
Best Regards
Maggie
@Anonymous , you can join them to the same date table and use userelation.
Refer my blog for example: https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |