Forum Discussion

dantedg1's avatar
dantedg1
Frequent Visitor
8 years ago

Distribute total days in months

Hello,   Currently I am working on a project in which we have both a start and an end date as data. How can I distribute the days in months to then graph each month? For example:   Begining Date...
Need Help
Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
8 years ago

Hi,

 

You may refer to my solution in this PBI file.

 

Hope this helps.

dantedg1's avatar
dantedg1
Frequent Visitor
8 years ago

Hi Ashish,

 

Thank you for your support. The problem is that i have lots of data, for example:

 

Begininig Date         End Date             Days

01/01/2018              02/20/2018             51

02/02/2018              02/25/2018             24

01/04/2018              05/05/2018             35

 

Desired output:

 

Days in January= 58

Days in February= 44

Days in March = 0

Days in April = 30

Days in may 5

 

I would really appreciate if you could help me out with this issue. Thanks again.

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    8 years ago

    Hi,

     

    That is exactly what my solution will do.  Just add more beginning and ending dates and click on refresh.