Forum Discussion
Rebuild Debt
Hi, Syndicate_Admin ;
I'm sorry, all the words in your table are In Spanish, I may not understand some of them. Secondly, could you share the results you want to output? So you can understand your logic.
The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.
Looking forward to your reply.
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I detail below the logic that I could solve in Excel format. The intention is to be able to develop it in Power BI so that in this way you can reconstruct a delinquent balance of a client depending on the calendar date selected in the filter.
1-Excel Table
Cut-off Date = Date Selected in the filter (calendar date)
2-To be able to reconstruct the debt of the clients, according to the date selected in the calendar filter.
the logic that is used in the excel file is as follows
AE BALANCE 3-column =SI(B30<$C$1;SI(K30<$C$1,0; F30);0)
Column AF STATE =IF(AE30>0,SI(J30<$C$1;" EXPIRED";" TO BE OVERCOME");0)
My query is how I can apply this logic in Power BI.
From the option "report" creating measures or from the option "data"?. From the Data option can I link the date selected in the report filter?
I would appreciate your help.
Thanks a lot.