Combine column by if

[Anonymous]

Hello all

Simple scenario, but i cant figure out a solution by myself...

Have a table with 2 columns: [ValueWhenEven] and [ValueWhenOdd]

I should display the column that matches the next weeks number.

For example: Next week is no 14, this is even, so i should show [ValueWhenEven].

I though of creating a column with the following formula, but it does not work:

Combined = if(MOD(SELECTEDVALUE(DateTable[Week]);2) = 0; 'Operatives'[ValueWhenEven]; 'Operatives'[ValueWhenOdd])

I think this is because im using a column, so the value cant refresh itself.

Is there a way to do this with a measure?

FYI: It always shows the [ValueWhenEven] value

[Anonymous]

Works now with a measure like this:

Combined = IF([OddOrEven] = "even"; FIRSTNONBLANK('Operatives'[ValueWhenEven];TRUE());FIRSTNONBLANK('Operatives'[ValueWhenOdd]; TRUE()))

But i cant drag it into my matrix, is there a way to do that?

[Anonymous · Accepted solution]

Since it's a measure it can only go into the Values secttion. If you want to put it on rows/columns/slicers/etc is has to be a column in your data. Can be calculated column or a column that is created in Power Query.