Forum Discussion
COINCIDIRX function
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))
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.
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))