Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
Hey,
I am working on a few measures that calculate invoices due
I want to have it like
Due 1-30 Days
Forumla # here
Due 31-60 Days
Formula # here
Due 60 days +
Formula # here
________________________________________________________
Here is what I have
DaxFormula =
CALCULATE(
COUNTROWS('VendorLedgerEntries'),
'VendorLedgerEntries'[Due_Date] > TODAY() &&
'VendorLedgerEntries'[Due_Date] <= TODAY() + 30
)
________________________________________________________
For this one it keeps counting the past-due invoices, I want to count those separately on another measure
Any help with why this is happening?
Thanks!!!
Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot). Leave out anything not related to the issue.
https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.
https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
| User | Count |
|---|---|
| 20 | |
| 10 | |
| 9 | |
| 4 | |
| 4 |
| User | Count |
|---|---|
| 33 | |
| 31 | |
| 19 | |
| 12 | |
| 11 |