COINCIDIRX function

Administrator

4 years ago

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
Solution Sage
4 years ago
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))

Forum Discussion