Forum Discussion

Cookistador's avatar
Cookistador
Icon for Super User rankSuper User
3 years ago
Solved

Show days in month between two dates

Hi Everyone,   I have a table with a start date and end data for Employees/Trainees, and I would like to get the days that ressources are working for a company by month So imagine, I have this kin...
Need Help
  • Manoj_Nair's avatar
    Manoj_Nair
    3 years ago

    Cookistador - pls try this PBIX FILE, 

    We worked on the power query part and taken into account only April Month to keep it simple and to give you an idea on one way to approach your requirement. You can replicate the same logic for other months.

    Let me know how you are going about it. 

    If this answered your question I would be happy if you could mark my post as a solution and give it a thumbs up

     

    Best regards

    Manoj Nair

    Linkedin - https://www.linkedin.com/in/manoj-nair-%E2%98%81-344666104/

Manoj_Nair's avatar
Manoj_Nair
Icon for Solution Supplier rankSolution Supplier
3 years ago

Cookistador - pls try this PBIX FILE, 

We worked on the power query part and taken into account only April Month to keep it simple and to give you an idea on one way to approach your requirement. You can replicate the same logic for other months.

Let me know how you are going about it. 

If this answered your question I would be happy if you could mark my post as a solution and give it a thumbs up

 

Best regards

Manoj Nair

Linkedin - https://www.linkedin.com/in/manoj-nair-%E2%98%81-344666104/