Forum Discussion

thomas_coltrain's avatar
thomas_coltrain
Frequent Visitor
3 years ago

Due Date Measure issue

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!!!

1 Reply