The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello Power BI community,
I am currently developing a Power BI report focused on analyzing invoices for our organization. This report aims to provide insights into our outstanding invoices, overdue amounts, and overall payment status. The analysis will help us manage our receivables more effectively and understand cash flow.
Currently, the report is displaying correct figures, but I need to refine the analysis further. Specifically, I need to ensure that the report does not display:
Credited invoices are defined based on the relationship between invoices and credit notes within our data structure. Here are the key fields in our Invoices table that help identify credited invoices:
Credit Note Generation: When a credit note is issued (i.e., PayDeal = "CN"), it serves as a reduction against a previously issued invoice. This means that the credit note effectively acknowledges that the customer will pay less than the originally invoiced amount due to various reasons (returns, discounts, errors, etc.).
Matching Amounts: To determine if an invoice should be excluded from the report, we compare the total amount of the original invoice (identified by SerNr) with the total amount of the corresponding credit note(s) (where CredInv matches the SerNr). If the amounts match, the original invoice is considered fully credited.
I would appreciate any guidance on how to implement these filters in my Power BI report to ensure that only relevant invoices are displayed.
Thank you for your assistance!
Hi @Anonymous ,
Add the following logic in your measure to compare the result:
VAR IsFullyCredited = InvoiceAmount = CreditedAmount
RETURN
IF(
IsFullyCredited || AdjustedRemainingAmount <= 0,
BLANK(),
AdjustedRemainingAmount
)
Best regards,
Joyce
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I tried but its still showing the invoices. F.Y.I when calculating its actually ignoring fully credited invoices as intented. My problem is its still displaying the fully credited invoices.
User | Count |
---|---|
25 | |
12 | |
8 | |
8 | |
7 |
User | Count |
---|---|
28 | |
13 | |
12 | |
12 | |
6 |