Forum Discussion
Solved
Merge Queries - Bring Latest Value only
I am trying to merge queries - brining in the tempoary support table into the Store List. I am looking to only get the Latest Support Date vs brining all items over. SEe below , I'd only bring over...
You should just be able to create a max measure. Last Date = MAX( 'Temporary Support'[Support Start Date] ). Then in your visual pull in Store # and this measure.
Is there a requirement these tables actually be merged in Power Query? Or are you able to accomplish this with DAX measures?
You should just be able to create a max measure. Last Date = MAX( 'Temporary Support'[Support Start Date] ). Then in your visual pull in Store # and this measure.
CoreyP Sorry I tried the above measure - but since I'm using the Store list to merge into and there should only be 1 record for each in that list and in the temporary support the store # may be multiple, when I add the measure to the table visual, it creates duplicate rows for numerous stores.