Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
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 |
---|---|
12 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
24 | |
19 | |
14 | |
10 | |
7 |