Forum Discussion

kh0050's avatar
kh0050
Frequent Visitor
5 years ago
Solved

Count Statement in Power BI - Urgent

Hi All Please help me to write the below statement in Power BI?   CASE WHEN `TableA`='-' THEN 0 ELSE CONCAT(`TableA`,'0') END   Many Thanks  
Need Help
  • v-kelly-msft's avatar
    v-kelly-msft
    5 years ago

    Hi kh0050 ,

     

    If you need a calculated column ,use below dax expression:(based on my sample table)

    Column = IF('Table'[A]="-","0",'Table'[A]&0)

    If you need a measure,use below dax expression:

    Measure = IF(MAX('Table'[A])="-",0,MAX('Table'[A])&0)

    For both method,you would see:

     

    For my sample .pbix file,pls see attached.

     

    Best Regards,
    Kelly

    Did I answer your question? Mark my post as a solution!

     

kh0050's avatar
kh0050
Frequent Visitor
5 years ago

Thank you so much Kelly!