Forum Discussion
Solved
Problem with BLANK value
Hello,
I would like to know if someone can help me. In this DAX formula I would like that in case any of variables returns a BLANK value, instead of BLANK it is "Zero". Thks a lot!!
Deuda a LP =
VAR Deudalp =
CALCULATE(
[BS],
dBalance[CUENTA] = "170"
)
VAR Deudalpvinculadas =
CALCULATE(
[BS],
dBalance[CUENTA] = "160"
)
VAR Result =
Deudalp + Deudalpvinculadas
RETURN
Result
Hi Sleathbcn ,
How about
IF ( result = BLANK(), 0, result )
Does this help? 🙂
/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/
2 Replies
Hi Sleathbcn ,
How about
IF ( result = BLANK(), 0, result )
Does this help? 🙂
/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/Yes!! Thks Tom.
Rgds
