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 ,

 

It's always nice if you can supply a sample data and expected output. The more detailed the information the better. With what you've given, the best anyone can do is nudge you in the right direction.

 

Your expression would be:

CALCULATE([YOUR_MEASURE], YOUR_DATE_FIELD > TODAY() - 7 || YOUR_INVOICE_FIELD = BLANK() )
  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi Hnguy,

                     Thanks for quick reply.

    i want to calculation as if current date - invoice date >7days or invoice date is null.

    i dont have any measures.

     

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

      Hi Anonymous ,

       

      If you don't currently have a base measure, then it would be the aggregate value of whatever field you're attempting to calculate.

       

      Replace [YOUR_MEASURE] with whatever you're attempting to do... perhaps a SUM, AVERAGE, MAX, etc.

       

      Am I understanding your request?

  • 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.