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
jcastr02
Post Prodigy
2 years agoPijushRoy Thank you - would you be able to share a sample Pbix file, please?
PijushRoy
Community Champion
2 years agojcastr02
Find the report link - https://drive.google.com/file/d/1gSyTaN9qLUmzYMwul37Z4FSxmsqLLr67/view?usp=sharing
- jcastr022 years ago
Post Prodigy
This worked Thank you!