Forum

Hi Loren, Welcome to our forum! You say "however that table that pulls the data from the pivots does not update automatically", what table? How ...

Glad you figured it out, Peter!

Hi John, I'm not sure there's an easy way to fix this data because there's a different number of rows in each group of weeks. i.e. there's no consi...

Hi Maarten, GETPIVOTDATA is covered in session 7.10 of the Power Pivot course. I would get the formula working in the spreadsheet before moving it ...

You can apply all transformations to one column and then copy that query and edit the column number being referenced in the M code to point to the nex...

Hi Varun, Welcome to our forum! Thanks for sharing your file, however it's referencing a source file saved on your PC that you didn't share, so ...

Hi Alexander, Welcome to our forum and thanks for sending in your PDF via email. As it contains confidential data I won't share it here, but the so...

Hi Maarten, If you look at the blue and red conditional formatting formulas you'll see that they have double quotes around the formula. Remove thes...

Hi Peter, Presumably you're filtering out the data you don't need that you mention in paragraph 1 before closing and loading the query, so Power Qu...

Hi Vicky, I've not heard of this issue before. I'd try repairing Excel to see if that helps. Of course I assume you've already tried rebooting. ...

So pleased to hear you got it working, Peter!

Hi Laurence, Try this file. Note: the order of the conditional formatting rules is important. I also changed the end dates to fall in the month the...

Hi Peter, 1. The status dimension table can not be a dimension table because every company is not listed. i.e. it only lists those that have a stat...

Hi Laurence, Thanks for clarifying. I assumed that the start and end dates were simply the first of each month because you are only tracking at a m...

Did you use Windows or Orgnaizational Account? Try both of these as it will depend on the type of account you have as to which credentials option you ...