Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Calculate Dates

Hi PowerBI newbiew here, 

 

Badly need help on how to calculate the date difference  ( duration days) of the following but only those with values then sum the total duration in a new calculated column. 

 

Thank you so much.

 

A.

  • Date Diff = Offer Accepted - New
  • Date Diff = Offer Accepted - Added from Talent pool
  • Date Diff = Offer Accepted - New quick Apply
  • Date Diff = Offer Accepted - Added to List

B. 

  • Date Diff = Hired - Offer Accepted
  • Date Diff = Hired no export - Offer Accepted
  • Date Diff = Hired usa - Offer Accepted
  • Date Diff = Hired usa no export - Offer Accepted
  • Date Diff = Hired  canada - Offer Accepted
  • Date Diff = Hired canada no export  - Offer Accepted

And sum the days

NewAdded From Talent PoolNew - Quick ApplyAdded To ListOffer AcceptedHiredHired (no export)Hired - USAHired (no export) - USAHired (no export) - CanadaHired - Canada
09/10/2019nullnull09/10/201925/10/201925/10/2019nullnullnullnullnull
nullnullnull03/01/202003/01/202003/01/202013/12/2021nullnullnullnull
null07/12/2021nullnull17/12/2021nullnullnull23/12/2021nullnull
nullnull11/08/2022null22/08/2022nullnull02/09/2022nullnullnull
23/01/2020nullnull23/01/202005/04/2022nullnullnullnull05/04/2022null
30/01/2020nullnull30/01/202006/01/202205/02/2020nullnullnullnull10/01/2022

 

Need Help

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Not sure I understood correctly, but I think you might want to follow this general pattern:

    IF(
        ISBLANK([Startdate])=FALSE AND ISBLANK([EndDate])=FALSE,
        COUNTROWS(DATEWBETWEEN(DateColumn, StartDate, EndDate)),
        "NaN"
    )