Forum Discussion
Sum rows depending on a condition
Hello, I am running a report in Power Bi (SQL data) where I have hunders of companies. The goal is to track if the discount is properly applied in the system. The discount applies 5% for 2 or mo...
Hi,
This isn't really a solution as your data sounds quite variable (Customer names are always a pain!) but I'd suggest you need some additional fields within the DB or lookup tables creating within PQ (Exception Customers and Customer Groups).
I think once you have these applying a logic for which rate should be applied should be quite simple.
Hope that helps
- That's what I did. Good suggestion. Thank you!