Forum Discussion

ivanhaldaco's avatar
ivanhaldaco
New Member
6 years ago

Using date as a logical test in an IF function in a measure

Hi! I'm trying to create a calculated measure  (let's call it measure 3) that before one date (let's say November 2018), returns the value of another measure (measure 1) and after that date, returns...
ahmedoye's avatar
ahmedoye
Icon for Responsive Resident rankResponsive Resident
6 years ago

ivanhaldaco , try using something like

 

Measure 3= IF(SELECTEDVALUE(Datetable[Date])<DATE(2018,11,01), Measure1, Measure 2)

If this answers your question, kindly kudo & mark as solution so others can benefit from it.