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.
Hello,
From the below sample table,
I want to present the jobs which are active between Opened date and closed date.
in the second chart I tried for the jobs between 01/02/2022 and 31/12/2025 but some how date filter is not working properly.
Here my requirement is in the second chart I should see the jobs circled in yellow as well as jobs which have no opening date and closing dates. Please help.
I'm providing the screenshot of the calendar table and its links.
Solved! Go to Solution.
Hi, @kkalyanrr
Please check the below pictures.
By seeing your screenshot, I cannot know which one is an active relationship and which one is an inactive relationship.
So, I decided to make both inactive relationships.
In my case, I prefer to make all inactive relationships if there are more than two date-related columns in one fact table. This makes me not to have any confuse which one is active and which one is inactive. If I want to activate one of those, I can simply use USERELATIONSHIP function.
In order to dynamically show the result by changing the date slicer, the measure is needed like below.
Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.
Linkedin: linkedin.com/in/jihwankim1975/
Twitter: twitter.com/Jihwan_JHKIM
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Hi, @kkalyanrr
Please check the below pictures.
By seeing your screenshot, I cannot know which one is an active relationship and which one is an inactive relationship.
So, I decided to make both inactive relationships.
In my case, I prefer to make all inactive relationships if there are more than two date-related columns in one fact table. This makes me not to have any confuse which one is active and which one is inactive. If I want to activate one of those, I can simply use USERELATIONSHIP function.
In order to dynamically show the result by changing the date slicer, the measure is needed like below.
Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.
Linkedin: linkedin.com/in/jihwankim1975/
Twitter: twitter.com/Jihwan_JHKIM
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
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 |
---|---|
115 | |
99 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |