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])
v-henryk-mstf's avatar
v-henryk-mstf
Icon for Community Support rankCommunity Support
5 years ago

Hi andrewb95 ,

 

According to your description, I did a test and think that the solution provided by ryan_mayu  can meet your needs. If there is still confusion, please point out and provide the desired result, I will answer you as soon as possible.

 

 

 Looking forward to your reply.


Best Regards,
Henry


If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.