AP and AR Aging bases on Featured date and Dataset date

[Prakashrajan]

Hi every one 👍 

I'm having AP data set it have column (invoice data, Due date, and Invoice Amount)  in this added column Today Date for calculate Aging, . 

And  Due date have 01-09-2021 to 29-09-2022 , but  i want to do some perdition on feature date up to 4-10-2022 , if I select future date in slicer label mean it should show perdition of future bucket aging in Table 

Please help me on this 

[amitchandak · Accepted solution]

@Prakashrajan , you can aging based on the selected date

Sumx(Table, datediff(Table[Due Date], selectedvalues(Date[Date]) , day))

As this is measure for axis and slicer you need bucketing

Dynamic segmentation -Measure to Dimension conversion: https://youtu.be/gzY40NWJpWQ