Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

NEED HELP

Hi All,           I need help in calculating the dates difference for one of my scenario as below i want to calculate current date minus invoice date >7 or invoice date  is null as single calculati...
Need Help
  • v-zhangti's avatar
    v-zhangti
    3 years ago

    Hi, Anonymous 

     

    You can try the following methods.
    Sample data:

    Column:

    Difference = DATEDIFF([Invoice date],TODAY(),DAY)

    Measure = CALCULATE(SUM('Table'[Count]),FILTER(ALL('Table'),[Difference]>7))
           +CALCULATE(SUM('Table'[Count]),FILTER(ALL('Table'),[Invoice date]=BLANK()))

    Is this the result you expect?

    Best Regards,

    Community Support Team _Charlotte

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

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi hnguy,

below is the screen shot of data.i want to calculate the current date - invoice date >7 or invoice date is null so that i know how many invoices are delayed

 

v-zhangti's avatar
v-zhangti
Icon for Community Support rankCommunity Support
3 years ago

Hi, Anonymous 

 

You can try the following methods.
Sample data:

Column:

Difference = DATEDIFF([Invoice date],TODAY(),DAY)

Measure = CALCULATE(SUM('Table'[Count]),FILTER(ALL('Table'),[Difference]>7))
           +CALCULATE(SUM('Table'[Count]),FILTER(ALL('Table'),[Invoice date]=BLANK()))

Is this the result you expect?

Best Regards,

Community Support Team _Charlotte

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