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.

hnguy71's avatar
hnguy71
Icon for Super User rankSuper User
3 years ago

Hi Anonymous ,

 

Fantastic! You've supplied a sample output, do you mind supplying some sample input as well? How did you get those 1s and 4s when the current date is December 8, 2022?

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    HI hnguy,

                        its the invoice count i placed for test data.