SAP BO to DAX

[rishari]

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

[olgad · Accepted solution]

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