The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
I am creating a dashboard for absence reporting last week I had help from this community to create the following dax
Hi @Michalison ,
Can you provide the relevant test data, so that I can answer for you as soon as possible.
How to Get Your Question Answered Quickly - Microsoft Power BI Community
Looking forward to your reply.
Best Regards,
Henry
No that does not work - I need it to list on a table the name and how many episodes of absence they have had in the last six months if they have had more than 3 episodes I count them by the start date of the sickness period not the staff ID
@Michalison , Assume you have employee id and the above measure
countx(Values(Absence[Employee ID]) , if([rolling 6 months]> 0, [Employee ID], blank() ) )
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
98 | |
92 | |
90 | |
72 | |
69 |
User | Count |
---|---|
232 | |
128 | |
117 | |
82 | |
82 |