Forum Discussion
Solved
Can't create date bucket with DAX if statement
Hi all! I am trying to create a date bucket using DAX to filter date ranges from last 3 months, last 6 months, and previous year. This is the code that I have: Date Bucket = IF('Vendor Inven...
TODAY() is 2023-03-02
MONTH(TODAY() -3) means TODAY()-3, which is 2023-02-28 and a month from this is 2.
MONTH(TODAY() -6) means TODAY()-6, which is 2023-02-25 and a month from this is also 2.
YEAR(TODAY() -1) means TODAY()-1, which is 2023-03-01 and a year from this is 2023.
'Vendor Inventory'[Date Received] >= TODAY() means "is my date received is equal or greater than today"
So you are looking for todays() and futures dates that is also lower than a some NUMBER (not date). That's why all your rows are in Other bucket. There is no chanse that something will match to this condition. 🙂
