Forum Discussion
Solved
COINCIDIRX function
Good afternoon
I would like to use the COINCIDIRX or COINCIDIRX function in powerbi, what would be the corresponding function?
Greetings and thank you very much.
I think I have understand what do you can use DAX IF statement like below to get the position of non zero value.
Column = IF(ColA<>0;1;IF(ColB<>0;2;0))
5 Replies
Maybe these
CONTAINSSTRING() or lookupvalue() or [column] in {"x","y","z"}
Enjoy !
Good
the comparison is between two columns:
the formula I want to make is as follows: COINCIDIRX (TRUE; Column A:ColumnB<>0;0)
how could I do this with two columns of powerbi.
Greetings.
You can't search in 2 column like your formula.
Can you give me more detail please ? Data sample and what you expect
