Forum Discussion

RahulPBI's avatar
RahulPBI
Helper I
6 years ago
Solved

Calculated Column With If Then Show Null

Hi Experts I have a calculated column that calculates the number of days between two dates and excludes any holidays. Managed to do that with help from members on this forumn. Its been working perfe...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    6 years ago

    So, like this?

     

    Late = 
  IF(
    [DiFOT vs Promise] = "On Time",
    BLANK(),
    CALCULATE(
      SUM('Date Dimention'[IsWorkday]),
      DATESBETWEEN(
        'Date Dimention'[FullDateAlternateKey],
        RF_DIFOT_Report[Promised Ship Date v1], 
        RF_DIFOT_Report[Actual Ship Date]-1
      )
    )
  )

     

Greg_Deckler's avatar
Greg_Deckler
Community Champion
6 years ago

So, like this?

 

Late = 
  IF(
    [DiFOT vs Promise] = "On Time",
    BLANK(),
    CALCULATE(
      SUM('Date Dimention'[IsWorkday]),
      DATESBETWEEN(
        'Date Dimention'[FullDateAlternateKey],
        RF_DIFOT_Report[Promised Ship Date v1], 
        RF_DIFOT_Report[Actual Ship Date]-1
      )
    )
  )

 

  • RahulPBI's avatar
    RahulPBI
    Helper I
    6 years ago

    Thanks Greg

    Worked like a charm