COINCIDIRX function

[Syndicate_Admin]

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.

[freginier]

Maybe these

CONTAINSSTRING() or lookupvalue() or [column] in {"x","y","z"}

Enjoy ! 

[Syndicate_Admin]

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.

[freginier]

You can't search in 2 column like your formula.

Can you give me more detail please ? Data sample and what you expect 

[Syndicate_Admin]

Bunas,

Of course

I give you an example of data and what I want to do:

Hours	Daily Market Price day 28/01/2022: ColumnaA	Market Price Diario day 29/01/2022: ColumnaB
1	10	9
2	20	8
3	30	5
4	0	7
5	15	6
6	16	8
7	17	0
8	200	22
9	3	10
10	1	15
11	5	6
12	6	7
13	52	8
14	55	23
15	52.3	52
16	35	23.3
17	36.9	4
18	25	0.23
19	24	20
20	27	80
21	32	78
22	22	56
23	100	20
24	0	0

we have the table above, because I want the match sheet to do the following:

time 1 = MATCHX (TRUE,ColumnAHora1:ColumnaBHora1<>0;0)

When applying that function what I should return is a 1, since in columnNow1 the criterion of 10 is non-zero is met.

time 4 = MATCHX (TRUE,ColumnAHora4:ColumnaBHora4<>0;0)

When applying that function what I should return is a 2, since in column BHora4 the criterion of 7 is non-zero is met.

hour 24 = MATCHX (TRUE,ColumnAHora24:ColumnaBHora24<>0;0)

When applying that function what I should return is a 0, since the two values are 0.

I hope I have explained well what I need.

Thanks for the help beforehand.

Greetings.

[freginier · Accepted solution]

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))