Forum

Hello, I am sorry, I am not so familiar with the M language, but perhaps there can be some useful information in these pages. But I was thinki...

Hi Anne, You should be able to change the source folder path using the Advanced Editor in Power Query Editor. You can also change source path from ...

Hi Brittany, If H2 only has Y or N as parameters then you just need to do as Phil suggests. But if H2 is to have more inputs than just those two yo...

Hi David, In the blog section you can search for Power Query and you will find good information and examples on how to work with that tool.<-- i...

Hi Paul, Have you considered to use a Pivot Table instead? Just took a glimpse of your file and I do think you should consider to rearrange your da...

Hello, I am looking in the file uploaded by Sunny. You just need to add one extra condition in the formula in cell H4. Current formula is: =IF([...

Hi Charlie, You are welcome. I am glad I could help you with your issue. Br, Anders

Hello, Please try with adding the full path to the file. =SUMIF('F:BackupBST ExcelRisk[Workbook-A.xlsx]WBA'!D4:D11,5,'F:BackupBST ExcelRisk[Work...

Hi, My recommendation is to use Power Query, but below answer is how to reference using a formula. To reference to a range in another workbook y...

Hi Dorothy, It is always easier to give help if there is a file attached, so we can see the data. You don't have to have the real data in, just som...

Hi Charlie, Please check attached file to see if this is what you want. Br, Anders

Hi Frans, Well, this gave me some lessons learned. I previously thought that you only got a Power Pivot table when you connected two or more tables...

Thanks Frans, Seems the "rules" of how to use GETPIVOTDATA differs between a regular Pivot Table and a Power Pivot Table. I need to read more about...