Forum Discussion

andrewb95's avatar
andrewb95
Icon for Helper II rankHelper II
5 years ago
Solved

DateDiff with blanks

I have a table with data similar to below:   ID Date A Date B Date Diff 1 02.06.2021     2   09.07.2021   3 01.01.2021 05.01.2021 4 4 07.02.2021 01.02.2021 -6   A...
Need Help
  • ryan_mayu's avatar
    ryan_mayu
    5 years ago

    andrewb95 

    is this what you want?

    1 = countx(FILTER('Table',ISBLANK('Table'[Date B])),'Table'[Date A])

2 = countx(FILTER('Table',ISBLANK('Table'[Date A])),'Table'[Date B])

3 = countx(FILTER('Table','Table'[Date A]<'Table'[Date B]),'Table'[Date A])

4 = countx(FILTER('Table','Table'[Date A]>'Table'[Date B]&&NOT(ISBLANK('Table'[Date B]))),'Table'[Date A])
ryan_mayu's avatar
ryan_mayu
Icon for Super User rankSuper User
5 years ago

andrewb95 

is this what you want?

1 = countx(FILTER('Table',ISBLANK('Table'[Date B])),'Table'[Date A])

2 = countx(FILTER('Table',ISBLANK('Table'[Date A])),'Table'[Date B])

3 = countx(FILTER('Table','Table'[Date A]<'Table'[Date B]),'Table'[Date A])

4 = countx(FILTER('Table','Table'[Date A]>'Table'[Date B]&&NOT(ISBLANK('Table'[Date B]))),'Table'[Date A])