Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

IF/OR Results

Hello everyone...   I'm trying to create a calculated column I can use as a slicer to filter projects that have a budget minus forecast variance of -5 or greater (i.e. -6, -7, -8 too) OR greater...
Need Help
  • az38's avatar
    az38
    6 years ago

    Hi Anonymous 

    the statement seems good. maybe just a little tuning like

    Change Required = 
var _diff = 'Table'[Budget] - 'Table'[Forecast]
RETURN
IF(ABS(_diff) > 5),"Yes","No")
az38's avatar
az38
Icon for Community Champion rankCommunity Champion
6 years ago

Hi Anonymous 

the statement seems good. maybe just a little tuning like

Change Required = 
var _diff = 'Table'[Budget] - 'Table'[Forecast]
RETURN
IF(ABS(_diff) > 5),"Yes","No")
Anonymous's avatar
Anonymous
Not applicable
6 years ago

I like that much better and it's working. Thank you az38