Forum Discussion
Solved
SAP BO to DAX
SAP BO:
Flag = [S_ID] Where (Var A - Var B)>0 Or IsNull(Var B)
Power BI:
Flag = IF( ((Var A - Var B) > 0 ) || ( Var B = BLANK()), S_ID, 0)
It is not as expected in Power BI. Kindly help me on this
Flag = IF( Var A - Var B > 0, S_ID, IF( Var B = BLANK(), S_ID, 0))
Flag = IF( Var A - Var B > 0, S_ID, IF( ISBLANK(Var B ), S_ID, 0))
Any of these will do
1 Reply
- olgad
Resident Rockstar
Flag = IF( Var A - Var B > 0, S_ID, IF( Var B = BLANK(), S_ID, 0))
Flag = IF( Var A - Var B > 0, S_ID, IF( ISBLANK(Var B ), S_ID, 0))
Any of these will do