Forum Discussion
IF measure does not Work
Hey Guys, something stranger here.
If measure not working.
REPDEF FINAL2 = if([REPDEF FINAL1]<>BLANK(),[REPDEF FINAL1])
My Table (visual)
SebSchoon1 , what is the expected output
Try like
REPDEF FINAL2 = if(not(isblank([REPDEF FINAL1])),[REPDEF FINAL1])
if you need 0
REPDEF FINAL2 = if(not(isblank([REPDEF FINAL1])),[REPDEF FINAL1], 0 )
or
REPDEF FINAL2 = [REPDEF FINAL1]+0
The information you have provided is not making the problem clear to me. Can you please explain with an example.
Appreciate your Kudos.
2 Replies
SebSchoon1 , what is the expected output
Try like
REPDEF FINAL2 = if(not(isblank([REPDEF FINAL1])),[REPDEF FINAL1])
if you need 0
REPDEF FINAL2 = if(not(isblank([REPDEF FINAL1])),[REPDEF FINAL1], 0 )
or
REPDEF FINAL2 = [REPDEF FINAL1]+0
The information you have provided is not making the problem clear to me. Can you please explain with an example.
Appreciate your Kudos.Hello,
Wow, i do not understand why i have to do this
Power Bi is extremely hard to handle!!
