cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
MSanchezz
Frequent Visitor

Aging Days Overdue Calculated Column

Hi All,

 

can you please help me with this issue I have? Currently, I have two tables, one for date and another for customer transactions. And I want to have a column where it will show the age of my receivables. Last date in my date table is 12/31/2025 and in my date difference, my due date computes against 12/31/2025. What should I do to make it so that the difference will be from the selected value in my slicer?

 

relationship on the date and customer transactions is the Posting Date from customer transactions.

MSanchezz_1-1616763834809.png

If measure is the only way for classification of current, 1-30 days due, 31-60 days dues, etc. what can be the way to make the classification be the axis in my stacked bar chart?

 

Thank you so much.

 

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@MSanchezz , if you want to calculate age against max date or today you can have column

 

Age = Datediff([Due date], today(), day)

 

Using switch , you can create a bucket -new column -https://www.youtube.com/watch?v=gelJWktlR80

 

But it is based on the selected date, then you need to measure

 

Age = Datediff([Due date], selectedvalue(Date[Date]) , day)

 

In this case, you need to create a bucket using an independent table - https://www.youtube.com/watch?v=CuczXPj0N-k

 

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!! !!
Dashboard of My Blogs !! Connect on Linkedin

Learn Power BI Beginners !! Advance Power BI Concepts !! Power BI For Tableau User !! Learn Power BI in Hindi !!
Proud to be a Super User!

View solution in original post

2 REPLIES 2
v-jingzhang
Community Support
Community Support

Hi @MSanchezz 

I don't 100% understand your requirement. You want to calculate the difference between which two dates? The date slicer selects dates between 1/1/2018 and 3/26/2021, and the table shows Due Date is 3/25/2021. Is there a connection between them? And you want the difference between 3/26/2021 and 12/31/2025? Or I totally understand it wrong? Can you describe the output with some sample data to help us understand your requirement better?

 

Regards,
Community Support Team _ Jing

amitchandak
Super User
Super User

@MSanchezz , if you want to calculate age against max date or today you can have column

 

Age = Datediff([Due date], today(), day)

 

Using switch , you can create a bucket -new column -https://www.youtube.com/watch?v=gelJWktlR80

 

But it is based on the selected date, then you need to measure

 

Age = Datediff([Due date], selectedvalue(Date[Date]) , day)

 

In this case, you need to create a bucket using an independent table - https://www.youtube.com/watch?v=CuczXPj0N-k

 

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!! !!
Dashboard of My Blogs !! Connect on Linkedin

Learn Power BI Beginners !! Advance Power BI Concepts !! Power BI For Tableau User !! Learn Power BI in Hindi !!
Proud to be a Super User!

View solution in original post

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.