Thank you for your offer Anders but the data is confidential so I would have to create a synthetic replica for you to look at. I've partially solved t...
Hi, I've partially solved it. I put this calculated column in my Date Calendar: Backlog = CALCULATE(SUM('Order Summary'[Order Amount]),FILTER(...
Hello Anders, That would only give the backlog for today and only for orders that haven't shipped. What I am trying to achieve is a view of the ...
Solved it: =calculate([Total Orders $],DATESBETWEEN(Dates[Date],LASTDATE(Dates[Date])-364,LASTDATE(Dates[Date]))) Peter
oops, looks like I was getting ahead of myself. I've just started Time intelligence functions chapter in PowerQuery and see the PREVIOUSYEAR function....
Hi again, Attached is the excel equivalent of what I am trying to achieve in a pivot table for rolling and trailing annual performance Rega...
Hi Mynda, I want each month column to contain the sum of the preceding 12mths, so January 2021 would contain the sum of Feb 2020 to MTD Jan 2021, F...
Thanks Mynda! I'll go through my PQ steps and put query foldable ones first. I haven't got onto my Power BI course yet, so I'll check out increment...
Hi Mynda, Thanks for your prompt responses! 1) I have successfully used the merge function in PowerQuery (see 2 below) and then replaced the nu...
Two follow-on questions: 1) Could you explain the pros and cons (or elegance) of the merge method versus just connecting in the data model the comp...