convert countif to pwerbi

[SravaniBudde]

Hi, how do we convert COUNTIFS(Table1[@[ESCAL_TO1]:[ESCAL_TO3_DT]],">0") excel formula to power bi.

ESCAL_TO1 is text with values ''adbcds'

and ESCAL_TO3_DT is date with value "10/31/2022"

dataset example:

ESCAL_TO1          ESCAL_TO3_DT

abcdw                 10/31/2022

fgdjfk                   08/31/2022

                            07/31/2022

gdsjfk 

[SravaniBudde]

Hi the answer could be as below but problem is in our case escal to1 is text not date

[andhiii079845]

Sorry, i do not understand what you want. please describe it better 

[SravaniBudde]

Hi, we have an excel formula COUNTIFS(Table1[@[ESCAL_TO1]:[ESCAL_TO3_DT]],">0") we need to convert to power bi formula. how shall we do it.

and in this case ESCAL_TO1 data type will be text and data will be in text where as ESCAL_TO3_DT will have date as datatype.

So how do we convert the above formula in power bi.

[andhiii079845]

I do not really understand the idea behind your count? Can you please say the desired result for your example or make a good example with the underlaying data and you result 🙂 Thank you