Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
What is the best way to take a table of Account Payable information and total all the invoice amounts that are still open where the net_due_date is older than today.
Essentially, what is the total amount of invoices that are past the net_due_date.
I was starting down the path of If(net_due_date > today, sum(invoice total field) as a measure. I think I may be missing a row by row trigger. Thanks for the help, I'm still learning!
Solved! Go to Solution.
See if this helps.. Change the greater than as per your need.
Mark it as a solution if it works.
Kudos are nice too
This is great! I need to get better with how FILTER is interwoven in DAX.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
97 | |
85 | |
67 | |
59 |
User | Count |
---|---|
150 | |
120 | |
100 | |
87 | |
68 |