Forum Discussion

marsclone's avatar
marsclone
Icon for Helper IV rankHelper IV
5 years ago

From Power Bi to Power Pivot

Hello,   I want to use this formula in Power Pivot 2016. Is that possible? Thank you in advance! Kind regards Marcel   ScopeCurrentLevel = var level4 = if(ISINSCOPE(Financial_Statement_Layou...
Need Help
marsclone's avatar
marsclone
Icon for Helper IV rankHelper IV
5 years ago

edhans Fowmy 

 

You are both right!

My question is, how can i adjust this formula so it will work in Power Pivot. 

Thank you in advance 

edhans's avatar
edhans
Icon for Community Champion rankCommunity Champion
5 years ago

It depends marsclone - it isn't a simple swap. We'd have to see your report, your filter context, and the expected result.

COALESCE is easy though - 

IF(
   ISBLANK(Something),
   0,
   ISBLANK(Something)
)