Forum Discussion
AR aging trend graph
Ericshepdawg , For that fist create a datediff measure
datediff([InvoiceDueDate], today(), day)
and then do
Dynamic Segmentation Bucketing Binning
https://community.powerbi.com/t5/Quick-Measures-Gallery/Dynamic-Segmentation-Bucketing-Binning/m-p/1387187#M626
Dynamic Segmentation, Bucketing or Binning: https://youtu.be/CuczXPj0N-k
Hi Amit, thanks for the response. One question, wouldn't this only be a snapshot of the current time? I am looking to build a rolling trend over 12 months that's dynamic based on a slicer. I want to analyze each of the 12 months that occured before the date I select on my slicer, and plot each of those 12 months on a line graph. Wondering if the buckets could still be useful, but I would somehow need to turn them into a time based trend. The part I am struggling with the most is getting the measure to change the period end it's referring to in order to calculate AR aging. For example, I have no problem getting it to reference the current date, but I need it to calculate the aging from 12 different period end dates, in order to see the AR aging for all 12 months in the past in one graph. I hope this makes sense and thanks so much for your help!