topic Re: undefined in DAX Commands and Tips

undefined

Aruna4584 — Sun, 14 Jul 2024 20:56:11 GMT

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

Anonymous — Mon, 15 Jul 2024 01:01:53 GMT

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.

Aruna4584 — Mon, 15 Jul 2024 03:29:14 GMT

It will look like this

xyz wfh planned lea

Anonymous — Mon, 15 Jul 2024 05:26:58 GMT

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.