Forum Discussion

Helper III

5 years ago

Time Intelligence Invoice Date & Invoice Pay Date

Hi guys, just running into a brick wall here. My A/R team groups invoices by the month they were eventually paid and not by days. So for example. An invoice that was Invoiced in February 17th 2020...

Super User

5 years ago

cdawidow , ate you trying to look for an age bucket?

if they are from same table we can create

New column =

var _age = datediff([invoice Date], [paid date], day)

return

Switch(True() ,

_age <20, " Below 20" ,

_age <30 , " Between 20-30",

//Add others

)

But if these are not from the same table then you need to measure

datediff(Min(Table[invoice Date]), Max(Table2[paid date]), day)

Now you need to do segmentation or binning using an independent table

Dynamic Segmentation, Bucketing or Binning: https://youtu.be/CuczXPj0N-k

cdawidow

Helper III

5 years ago

Hi Amit, I am and I understand your measure. But my orginization focuses on the month the invoice is actually paid and not the days. For example. if a invoice is Issued in Feb but payed sometime in March then that would be in AGE 1. If that same invoice was paid in April, it would be Age 2 because it is paid in the month of April, 2 months after the issue month of February.