Calculated column not showing blank rows

Hello Anonymous 

You may try this:

From the drop down option of ID column > Select Show items with no data

For this, I have created the calculated column as per your scenario:

Column = 

VAR Col1 = IF(
            ISBLANK(Sheet1[Date 1]) || ISBLANK(Sheet1[Date 2]),
             BLANK(),
             DATEDIFF(Sheet1[Date 1], Sheet1[Date 2],DAY)
            )
VAR col2 = IF(
            ISBLANK(Sheet1[Date 2]) || ISBLANK(Sheet1[Date 3]),
             BLANK(),
             DATEDIFF(Sheet1[Date 2], Sheet1[Date 3],DAY)
            )
VAR Diff = IF(
    ISBLANK(Col1) || ISBLANK(col2),
    BLANK(),
    Col1 - col2
)
RETURN
Diff

Cheers!
Vivek

If it helps, please mark it as a solution
Kudos would be a cherry on the top 🙂

https://www.vivran.in/

Connect on LinkedIn