Forum Discussion

sentsara's avatar
sentsara
Helper II
8 years ago

Latest BreakEven DAX Expression Value

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([Cur...
Need Help
v-juanli-msft's avatar
v-juanli-msft
Community Support
8 years ago

Hi sentsara

Try this 

lastest = CALCULATE(MAX([TRENDMONTH]),FILTER(ALL('Latest BreakEven'),[Current Rate 2019]<>BLANK()))
LatestBreakeven = CALCULATE(MAX([Rate Vs Breakeven]),FILTER(ALL('Latest BreakEven'),[TRENDMONTH]=[lastest]))

 

 

Best Regards

Maggie