Forum Discussion

sentsara's avatar
sentsara
Icon for Helper II rankHelper II
8 years ago

DAX Expression help needed

  Hi, I need to derive "LATEST Break Even" Dax Expression  based on calculated column "Rate Vs Breakeven"   DataSet name: QBM   Rate Vs Breakeven = if([Current Rate 2019]=0,blank(),if(ISBLANK([...
Need Help
Anonymous's avatar
Anonymous
Not applicable
8 years ago

What is  the logic ( not formula) for Rate Vs Breakeven ?

 

Thanks
Raj

sentsara's avatar
sentsara
Icon for Helper II rankHelper II
8 years ago

Hi Rajendran.

 

"Rate Vs Breakeven" is the Caculated Column.

Logic for "Rate Vs Breakeven" is -->  "Current Rate 2019" - "Monthly Break Even"

Formula: Rate Vs Breakeven = if([Current Rate 2019]=0,blank(),if(ISBLANK([Current Rate 2019]),blank(),[Current Rate 2019]-[Monthly Break Even]))