March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
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...
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
22 | |
19 | |
17 | |
9 | |
5 |
User | Count |
---|---|
37 | |
29 | |
16 | |
14 | |
12 |