The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hi
Iam new to power bi.
I have leave tracker in Excel for a month.
We have planned leaves sick leaves wfh category in that excel.
I need to show in my power bi dashboard, names of employee for each category for the current working week
How can I make this measure.
Can anyone help
Solved! Go to Solution.
Hi @Aruna4584
Based on your needs, I have created the following table.
Then you can use the following dax to calculate the week of the current date.
Weeknum = WEEKNUM([Date])
Then you can create two slicers, putting "weeknum" and "category" into each of them.
Select the number of weeks and the type of leave you want to view, and the name of the corresponding employee will be displayed.
Best Regards,
Jayleny
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Aruna4584
Can you provide detailed sample pbix file and the results you expect.So that I can help you better. Please remove any sensitive data in advance.
Best Regards,
Jayleny
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
It will look like this
xyz wfh planned lea
Hi @Aruna4584
Based on your needs, I have created the following table.
Then you can use the following dax to calculate the week of the current date.
Weeknum = WEEKNUM([Date])
Then you can create two slicers, putting "weeknum" and "category" into each of them.
Select the number of weeks and the type of leave you want to view, and the name of the corresponding employee will be displayed.
Best Regards,
Jayleny
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
Check out the July 2024 Power BI update to learn about new features.
User | Count |
---|---|
20 | |
17 | |
15 | |
15 | |
14 |
User | Count |
---|---|
25 | |
25 | |
20 | |
20 | |
19 |