adding an if greater than date into a measure

[maurcoll]

Hi

I am trying to amend a measure based on the month

i need it say if monthyear is greater than feb 2024 then divide by a else by b

the measure i have is

divide (sum(Sales{Total]),
(Stores[Total])

what i need to do is 
if MonthYear is >= Feb 2024 ,
divide (sum(Sales{Total]),
(StoresA[Total]),

divide (sum(Sales{Total]),
(Stores[Total])

Thank you

Month Year is coming from a calendar table

[rajendraongole1 · Accepted solution]

Hi @maurcoll - You can achieve this by using an IF statement in your DAX measure as below

Sales_Per_Store =
IF(
SELECTEDVALUE(Financial[MonthYear]) >= DATE(2024, 2, 1),
DIVIDE(SUM(Sales[Total]), SUM(StoresA[Total])),
DIVIDE(SUM(Sales[Total]), SUM(Stores[Total]))
)

replace financial table as per your model.

Hope this works