Hi @curiousfellow 

it is possible

only error i see is that your are missing a braket (highlighted in red)

If (linenumber = 110,[column1]-[column2],

if (linenumber = 220, expression with variables))

also i guess you have column1, column2 and column3 as master measures and you could have problems because of data model or aggregation level on each measure.

remember that you can use the values of the columns by simply calling them within the same object using column(number), this will only considere measure columns and not dimensions columns.

my third column measure is:

if(Date>=makedate(2023,11,01),column(1)-column(2),
if(Date<makedate(2023,11,01),column(2)))

Hope this helps,

help users find answers! Don't forget to mark a solution that worked for you & to smash the like button!