Forum Discussion
Calculate Overdue Days
Hello Everyone,
I want to calculate Overdue Days of customer, i have data from Navision (SQL Server), I have 3 main tables,
Customer table (customer code & Name),
Customer Ledger Entry (Customer code, Due Date, Invoice No.)
Detailed Customer Ledger Entry (Customer Code, Invoice No, Posting Date, Outstanding Amount)
I want to calculate the overdue days without creating calculated column with summarize function or anyother way.
thsi is the report format
I want this expected result... and the report format
Kindly Help me to make relationship and calculate overdue days...
Thank You
2 Replies
Anonymous , refer the similar calculation on similar topic
https://community.powerbi.com/t5/Desktop/Calculate-amount-of-days-overdue-DYNAMIC/td-p/822599
Hi Anonymous ,
Could you please consider sharing some data or a dummy .pbix file for further discussion? It would help tremendously.
Please see this post regarding How to Get Your Question Answered Quickly:
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490Best Regards,
Yingjie Li
