Forum Discussion

ttcalendar's avatar
ttcalendar
Frequent Visitor
4 years ago

Calculating Status based on Two Dynamic Dates

Hi,   I would like to create a DAX measure to to define the customer sales status based on their last order date.   We have 4 statuses: Active:  Last Order Date between Today and Last 12 months ...
datesbetween
DAX
Dynamic
status
ERD's avatar
ERD
Icon for Community Champion rankCommunity Champion
4 years ago

Hi ttcalendar ,

you can use SWITCH and DATEADD functions.

If this post helps, then please consider Accept it as the solution ✔️to help the other members find it more quickly.