Forum Discussion

rishari's avatar
rishari
Frequent Visitor
3 years ago
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 ...
  • olgad's avatar
    3 years ago

    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