Forum Discussion
Anonymous
3 years agoNot applicable
Show data over time based on dynamic date selection
Hi 🙂 I want to make a report that shows how much a customer owes me in unpaid invoices over time. I should be able to change the date of interest in my analysis. So if I select a date in the past i...
amitchandak
Super User
3 years agoAnonymous , You have create a measure like
Assume you are using date table joined to date of your table
Days =
var _max = maxx(allselected(Date), Date[Date])
return
datediff(Max(Table[Due Date]), _max, day)
If need add filter Table Due > _max
Days =
var _max = maxx(allselected(Date), Date[Date])
return
calculate(datediff(Max(Table[Due Date]), _max, day), filter(Table, Table[Due Date] >_max ))
Then you can use dynamic Segmentation for bucketing
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