case statement

[sraj]

Hi,

Is it possible to convert this case statement into a power bi measure or column?

value  measure = CASE WHEN (real_held_in_val +pers_held_in_val) = 0 THEN 0 ELSE CAST((real_held_in_val - real_held_fin_val) + (pers_held_in_val - pers_held_fin_val) AS DECIMAL (18,4))/(real_held_in_val +pers_held_in_val)* 100 END  

Thanks for your help!!

[Manoj_Nair]

@sraj - pls try the PBIX file, I hypothetical created the dataset and measure assuming your data fits into.

case statement file 

If you need any help please letme know.
If I answered your question I would be happy if you could mark my post as a solution and give it a thumbs up  
 
Best regards
Manoj Nair
Linkedin - https://www.linkedin.com/in/manoj-nair-%E2%98%81-344666104/

[sraj]

HI there - I am unable to open this file for some reason.

[Manoj_Nair · Accepted solution]

@srajtry this again https://github.com/cloudcolor-uk/PowerBI/blob/main/2022_12_12_case%20statement.pbix