Last seen: Jun 27, 2026
Hi Murray, Thanks for uploading the file again. In the attached file you'll see the Prior On Hand BBLs and Daily Prod BOPD were calculated using Po...
Hi Alison, You can use Power Query to Pivot the data. The file attached shows the process. It's a bit complicated and you have to merge the columns...
A demo would be perfect, but I can't see it in the Production-Data-v1.0.xlsm file above.
Thanks for your kind words! Glad it's working now 🙂
Hi Murray, Can you please upload your Excel file again. It looks like it has been removed when you did the edit. Thanks, Mynda
Hi Jan, It looks like your Transaction Quantity column (I'm guessing it's the second column because there are no column headers on the screenshot),...
Hi Beth, Have you tried saving the file as a .xlsx to see if that makes any difference? Are you able to share a copy of the file, anonymized if ...
Hi Jan, I can't translate the formula above for you as it doesn't refer to column names, which you need for a Power Query IF. However, session 6.12...
Hi Murray, Great to see you're giving Power Query a go. Thank you for your detailed description and file. I've read through it several times but...
Hi David, I'm unable to open the file from that link. It tries to open in Excel Online, then says the file is too big and offers me the option to o...
Hi Mirjam, You need a dimension table for the Material that you relate your two fact tables (sales & stock) to. The dimension table contains a ...
Hi Dorothy, Edit the query and after the 'Source' step and add a filter that excludes the name of your query table. Just select the Source step, th...
Hi Mirjam, Great to see you're giving Power Query a go. If you want to retain the customer detail then what you want is a Power Pivot model, not...
Hi Denise, Are you able to load to a Table? What version of Excel are you using? Can you please attach a screenshot of the error in full screen so ...
Hi Matthias, Thanks for clarifying. It's great that you have a workaround. Although I'd still be inclined to avoid parameters for this scenario as ...