Hello DNA Community,
I have in theory a simple question, but in practice its looks harder to achieve, and this blocked me many times when trying to get coniditions inside my formulas.
What I have is a column with 0 & 1 depending on a specific Intern criteria. I need to retrieve an amount from column X if its 0 and an amount from colunm Y if its 1. It is simple in Excel IF(CellA1=1 ; True ; False) but in power bi its seems more difficult to create this row by row verification context. (the column only contains 0 or 1 nothing els)
See attach the data I m working with.