Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to Solution.
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!
Thank you so much Kelly!
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!