Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Hi,
We have raised some invoices and payments were received for those invoices BUT IN LUMP SUM way. Now we have to charge interest, since payment was received belatedly, can we do it in power query. below is the example:
Details of invoice
Date of Invoice | Amount |
01-01-2022 | 1000 |
05-05-2022 | 15000 |
07-11-2022 | 23000 |
02-03-2023 | 11200 |
Total Invoice Value | 50200 |
Details of payments
Date of payment | |
30-09-2022 | 25000 |
30-04-2023 | 25200 |
50200 |
Rate of interest is 5% chargeable from the last day of the month of the invoice till payment is made.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
9 | |
7 | |
7 | |
6 | |
6 |
User | Count |
---|---|
13 | |
11 | |
9 | |
6 | |
6 |