The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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...
User | Count |
---|---|
28 | |
10 | |
8 | |
6 | |
5 |
User | Count |
---|---|
33 | |
13 | |
12 | |
9 | |
7 |