Forum Discussion

jcastr02's avatar
jcastr02
Post Prodigy
2 years ago
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...
Need Help
jcastr02's avatar
jcastr02
Post Prodigy
2 years ago

CoreyP it can be a DAX, yes.

CoreyP's avatar
CoreyP
Solution Sage
2 years ago

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's avatar
    jcastr02
    Post Prodigy
    2 years ago

    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.

    • PijushRoy's avatar
      PijushRoy
      Community Champion
      2 years ago

      Hi jcastr02 

      Did you try POwer Query step I shared earlier? Is it solve your requirement? Or you are looking for DAX?

      • jcastr02's avatar
        jcastr02
        Post Prodigy
        2 years ago

        PijushRoy Thank you - would you be able to share a sample Pbix file, please?