Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
Can anyone help me out to replicate below formula in power bi:
CASE [Status]
WHEN 'Success' THEN 'Success'
ELSE 'Fail'
END
Hi @UditJ
If it is calculated column:
Flag = if ('CASE [Status]= "Success" than "Success","fail")
If it is a measure, you need some aggregation , not matter which if you visualizing it on row granularity, for example :
Flag measure = if (max('CASE [Status])= "Success" than "Success","fail")
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.