Forum Discussion

samoberoi's avatar
samoberoi
Helper III
2 years ago
Solved

Network days from a certain date

Hi All,   I have a query on some work which has previously been done on Excel and now it has to be done on Power BI. It is just to calculate the number of network days from a joining or leaving dat...
Need Help
lbendlin's avatar
lbendlin
Super User
2 years ago

Add a column to the Dates table in your data model that clearly identifies the working days for your scenario  (by region/country etc)

  • samoberoi's avatar
    samoberoi
    Helper III
    2 years ago

    Hi Ibendlin,

     

    Normal network days is working fine, but what if let's say a resource's  TO_DATE is showing 26th June 2024 and FROM_DATE column is showing blank for that particular resource , so it should calculate the Network days for June month starting from the first of June month till 26th June 2024 which will be 18 Network days. Similarly e.g if the resource's FROM_DATE is 26th June 2024 and TO_DATE column is showing blank for that particular resource, then it should calculate Network days from 26th June 2024 till the end of June month, which will be only 3 Network days. It doesn't filter number of capacity in days for a few specific resource.

    Thanks

    • lbendlin's avatar
      lbendlin
      Super User
      2 years ago

      What is your definition of weekend?  Are there any holidays in the affected period?

       

      Please provide sample data that fully covers your issue.
      Please show the expected outcome based on the sample data you provided.

      • samoberoi's avatar
        samoberoi
        Helper III
        2 years ago

        Hi Ibendlin, 

         

        The weekend should just be counted as Saturday & Sunday. No other holidays are necessary to be counted.

        Thanks