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
Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
8 years ago

Hi,

 

Are those formulas measures or calculated columns?  Share the link from where i can download your PBI file.  Share only relevant data in that file please.

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

Hi Ashish,

 

all are caculated columns.

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper 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
      Icon for Helper II rankHelper 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
        Icon for Super User rankSuper User
        8 years ago

        Hi,

         

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