Forum Discussion

Aruna4584's avatar
Aruna4584
New Member
2 years ago
Solved

undefined

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 ea...
  • Anonymous's avatar
    Anonymous
    2 years ago

    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.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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.

 

  • Aruna4584's avatar
    Aruna4584
    New Member
    2 years ago

    It will look like this 

     

     

     

    xyz wfh planned lea

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      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.