Forum Discussion
jcastr02
Post Prodigy
2 years agoMerge 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...
- 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.
- 2 years ago
jcastr02
Find the report link - https://drive.google.com/file/d/1gSyTaN9qLUmzYMwul37Z4FSxmsqLLr67/view?usp=sharing
PijushRoy
Community Champion
2 years agoHi jcastr02
Did you try POwer Query step I shared earlier? Is it solve your requirement? Or you are looking for DAX?
jcastr02
Post Prodigy
2 years agoPijushRoy Thank you - would you be able to share a sample Pbix file, please?
- PijushRoy2 years ago
Community Champion
jcastr02
Find the report link - https://drive.google.com/file/d/1gSyTaN9qLUmzYMwul37Z4FSxmsqLLr67/view?usp=sharing- jcastr022 years ago
Post Prodigy
This worked Thank you!