Looking for a suggestion on how to grab a value from a table and throw it in a column
In the visual I have attached, I want to add a column to the end of the visual that will grab the current meter reading based on the Service order number
I have created several measures that work well except this one below.
Hour Meter = LOOKUPVALUE(‘Hour Meters’[Current Meter Reading], ‘Hour Meters’[Service Order No.], “SVO12074” )
Needless to say I don’t want to hard code the value. I have only hardcoded it as test to see if I could grab the value for SVO12074. It was successful and pulled in the meter reading of 719. But, it didn’t play well with the rest of the rows of data. The issue I am having is that when I try to add a third argument to the LOOKUPVALUE function, it will only take a scalar value. I have also added my data model which may be suspect. I have also included the hour meter table so whomever looks at this may see the data.
Any help would be appreciated. I’m almost there, I am sure its something simple. Maybe I should be using another Dax function instead.