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
Phil_Seamark's avatar
Phil_Seamark
Microsoft Employee
8 years ago

HI sentsara

 

Is this what you are after?

 

Column = 
VAR LatestTrentMonth = MAXX(FILTER('QBM','QBM'[Current Rate 2019]>0),'QBM'[TRENDMONTH])
RETURN MAXX(FILTER('QBM','QBM'[TRENDMONTH] = LatestTrentMonth),'QBM'[Rate Vs Breakeven])