Forum Discussion
sraj
Responsive Resident
3 years agocase 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 - ...
- 3 years ago
srajtry this again https://github.com/cloudcolor-uk/PowerBI/blob/main/2022_12_12_case%20statement.pbix
Manoj_Nair
Solution Supplier
3 years agosraj - 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/
- sraj3 years ago
Responsive Resident
HI there - I am unable to open this file for some reason.
- Manoj_Nair3 years ago
Solution Supplier
srajtry this again https://github.com/cloudcolor-uk/PowerBI/blob/main/2022_12_12_case%20statement.pbix