Forum Discussion
Solved
case statement
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!!
3 Replies
sraj - pls try the PBIX file, I hypothetical created the dataset and measure assuming your data fits into.
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/
HI there - I am unable to open this file for some reason.
