Forum Discussion

sentsara's avatar
sentsara
Helper 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
sentsara's avatar
sentsara
Helper II
8 years ago

Hi Ashish,

 

all are caculated columns.

Ashish_Mathur's avatar
Ashish_Mathur
Super User
8 years ago

Hi,

 

This measure will work

 

=LOOKUPVALUE([Rate Vs Breakeven],Data[TRENDMONTH],CALCULATE(MAX(Data[TRENDMONTH]),FILTER(ALL(Data),[Rate Vs Breakeven]<>BLANK())))

 

  • sentsara's avatar
    sentsara
    Helper II
    8 years ago

    Hi Ashish,

     

    I'm not able to get the "Rate Vs Breakeven"  in LookupValueExpression. it seems "Rate Vs Breakeven" is a Measure value.

     

     

     

     

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Super User
      8 years ago

      Hi,

       

      [Rate v/s breakdown] should be a calculated column - as you had stated in your post.

      • sentsara's avatar
        sentsara
        Helper II
        8 years ago

        Yes I'm wrong...it's a Measure..