Forum Discussion

SravaniBudde's avatar
SravaniBudde
Frequent Visitor
3 years ago

convert countif to pwerbi

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 
 
Need Help

4 Replies

  • andhiii079845's avatar
    andhiii079845
    Icon for Solution Sage rankSolution Sage
    3 years ago

    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

  • SravaniBudde's avatar
    SravaniBudde
    Frequent Visitor
    3 years ago

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

     

     

     

    • andhiii079845's avatar
      andhiii079845
      Icon for Solution Sage rankSolution Sage
      3 years ago

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

      • SravaniBudde's avatar
        SravaniBudde
        Frequent Visitor
        3 years ago

        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.