Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi all,
I have a requirement to check if a user is eligibile for a specfic service and the eligibility criteria is his age should be >=55 years and also have >=10 years of service.
I have to show the total users who are eligible as of today, within 3 years and within 5 years.
Sample data:
I was able to calculate the total users as of today using the below:
years of service = DATEDIFF(service date, TODAY(),YEAR)
Service Check =
IF([years of service] >= 10 && [Age] >= 55,"Eligible","Not Eligible")
Can someone pls help with how we can show the get the count of users who are eligible within next 3years from today and next 5 years from today. Sample pbix file is available here.
Thank you.
Solved! Go to Solution.
you can try this
Proud to be a Super User!
you can try this
Proud to be a Super User!
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
87 | |
85 | |
68 | |
67 | |
64 |
User | Count |
---|---|
210 | |
118 | |
116 | |
81 | |
74 |