Last seen: Aug 23, 2025
Really sorry, but there's not much I can offer if you don't provide some real (though anonymized) data and the model you have already built (i.e. from...
When I follow your scenario, and just by clicking in the user interface, the M-code looks like this: Table.ReplaceValue(Source, "Notebook 5""x8""...
I believe your data is not in the correct format for the result you want to achieve in Power Pivot (PP). It's perfect, though, to work in Excel with f...
Fair enough. Hadn't noticed the comment re Power Pivot in the screen shot. Please upload an example file so that we don't have to construct something ...
Have a look at the attached. A fairly simple approach since you only asked for a 3-mth rolling average. But, bear in mind that you need at least three...
I thought of a simple Power Query solution. Would that work for you? See attached.
One way would be to use AVERAGE and OFFSET, where the offset is based on the first blank cell found in the range under M1 to M12. See attached.
I believe that the attached workbook does what you asked for. If not, please come back here.
When you connect to the file, you will see the content of the entire workbook. All visible tabs in alphabetical order with a checkbox in front of it. ...
Would be great if you could upload a file demonstrating what have and what you want. It's difficult to help without some real data to play with. Just ...
There is no attachment. Please try again and don't forget to press "Start upload" before you submit your reply.
I created a simple model based on your description and suspect, despite the fact that you created a calendar/date table, that you populated the pivot ...
You could use a technique described here: I've adapted it to your example in the attached file. One comment though. It tries to find matches...
There is no attachment. Please try again and don't forget to press "Start upload" before you submit your reply.
Consider a pivot table as demonstrated in the attached file. Or, if you are using a moder Excel version you could use UNIQUE and FILTER.