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.
jcastr02
Find the report link - https://drive.google.com/file/d/1gSyTaN9qLUmzYMwul37Z4FSxmsqLLr67/view?usp=sharing
This worked Thank you!