Forum

Hi Rick, Yes, they have been updated for 365 🙂 Mynda

Hi Mamie, With some helper columns you can do it. Best to do this in a table so the dynamic references update correctly. See attached. Mynda

Hi Jason, You should definitely be using Power Query to create your consolidated table before trying to load to Power Pivot or a create a PivotTabl...

Hi Wim, There's no query in this file to show what you're trying to do. When you click the Transpose icon on the Transform tab it doesn't insert a ...

Hi Salim, If you have Microsoft 365, you can use the FILTER function with the SEQUENCE function to create a list of weekday dates. And you can use ...

Hi Wim, The number of columns argument is optional. Simply delete it from the Transpose.Table formula and it should simply transpose all columns. ...

Hi Sunny, You can only specify sort order using one of the columns present in the data, e.g. a date column. You can't simply tell Power Query to ap...

Hi Fahim, In the working files for the course there is a homework activity file for session 1 numbered 1.07. It includes two practice cases and a s...

Glad you found a solution, Peter. If you want a way to avoid the running total resetting, you can use Power Pivot as described here.

Hi Mattias, Because time is represented as a decimal, I suspect there is a floating point rounding discrepancy between the timestamp and the rounde...

Answers should be in one column and the category in another. Not a separate column for each category. If you look at the query editor you'll see the d...

Hi Mattias, You could try replacing Number.Round with Number.RoundDown. I suspect it doesn't know what to do when it rounds up because it technical...

Yes, your data should always be stored in a Tabular Layout. From there everything is easy.

Hi Peter, Here is a tutorial on using PivotTables to show report pages as Catalin suggests. Mynda

Or you can do it in Power Query using a formula like this: =Time.From(Number.Round(Number.From(Time.From([timestamp]))*(24*60/15))/(24*60/15)) ...