Forum Discussion
jcastr02
Post Prodigy
Post ProdigyMerge 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.
jcastr02Post Prodigy
Post ProdigyCoreyP 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.
