Last seen: Aug 24, 2025
Not sure I can help. What happens is logical in the context of how PQ merging works. Each row with 'David' AND '1000' will be merged with all rows in ...
Have looked at your file but it's a bit difficult to jump in without knowing what exactly you have done. You connect on data on your own computer, loa...
I can see the Applied Steps in the GL query. Most of them make no sense, achieve nothing and can be removed. And when you merge on s.no, it will not w...
Thanks! I'm on a Mac right now and can't work on files with Power Pivots in them. Will be off to something else soon so will get back to you tomorrow ...
Thanks for the files .I've had a look at them but don't understand what you ask. Sorry. Can you include the expected results to both files?
If you intended to attach a file, please try again and don't forget to press "Start upload" before you submit your reply.
Could you please upload a file with some example data, so that we can see the structure of your model a the measures you have create already.
Since you provided a simplified example, the solution is also rather simplified (attached). For the YTD, I copied your pivot table, removed the Mon...
Please see attached in the PQ tab. Quite a few steps (split in separate queries), including changing the headings in the data table, and it probably c...
Please see attached. It's not the neatest solution and probably not the best either. But it's the best I can think of at the moment. Note that the ...
I'm sorry but don't understand. The file has very little data and doesn't seem to correspond the the cell references you mention. Can you upload a fil...
There is no attachment. Please try again and don't forget to press "Start upload" before you submit your reply.
Based on your comprehensive description I would suggest you focus on learning Power Query (PQ) and Power Pivot (PP). PQ can help you build a histor...
Great! Then, I believe the file I uploaded with my previous answer does the trick.
See if you can follow what I've don in the attached file. Since I couldn't work with your own queries as they connect to your Sharepoint folder, I add...