Forum Discussion
Helper IIIDAX Formula IF Statement Dates
msommerf - You could add a "Phase" column to your date table. Then in you could do this for your Calculated Column:
Phase Selection= var phase_today = CALCULATE(max('Dates'[Phase]) ,'Dates'[Date] = TODAY()) return IF([Phase] = phase_today, "Current Phase", "Not Current Phase")Cheers!
Nathan
Sorry if it's something stupid I am doing at this end.
Just learning the rope with DAX.
msommerf - You could add a "Phase" column to your date table. Then in you could do this for your Calculated Column:
Phase Selection=
var phase_today = CALCULATE(max('Dates'[Phase]) ,'Dates'[Date] = TODAY())
return IF([Phase] = phase_today, "Current Phase", "Not Current Phase")Cheers!
Nathan
- msommerf
Anonymous
Nathan,
Thanks for such a quick response.
Using your DAX, only today is set as the current phase?
I have a Phase column in my dates table (Phase) which has phases stored as:
2017 Phase 1
2017 Phase 2
2018 Phase 1
2018 Phase 2
2019 Phase 1
2019 Phase 2
If current month is April I need to set the current phase against months of Jan - Jul
If current month is August I need to set the current phase against months of Aug - Dec
regards
Mark.