Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Same Expression Different Results

Hi All,   Looking for help with a DAX expression/Calculated table. Context; I am looking to build a data model which tracks tonnage with a split on festival related delivery and non festival relat...
  • Anonymous's avatar
    Anonymous
    3 years ago

    Thanks for the responses.

    I'm not sure if it's my lack of understanding or experience but I couldn't implement the solutions in the above suggestions.

     

    What I have done is use the "LOOKUPVALUE" function and created a calculated coumn in my data.

    So rather than using a relationship between tables I've essentially used a VLOOKUP as you do in Excel to classify the row.  

     

    I'm not sure it's the best/most efficient/proper way to do this but at least it's worked.

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Thanks for the responses.

I'm not sure if it's my lack of understanding or experience but I couldn't implement the solutions in the above suggestions.

 

What I have done is use the "LOOKUPVALUE" function and created a calculated coumn in my data.

So rather than using a relationship between tables I've essentially used a VLOOKUP as you do in Excel to classify the row.  

 

I'm not sure it's the best/most efficient/proper way to do this but at least it's worked.