Forum

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)) ...

Hi Achille, Welcome to our forum. The formula for the weekend dates is referencing the wrong row. e.g. if you choose cell K8 and edit the condit...

Hi Gerrit, Welcome to our forum. The first rule of Excel is to store your data in a tabular layout. When you store it in a tabular layout, the repo...

Hi Erik, Welcome to our forum! If you just want to fill the blanks with the values from the cells above then try this: Select the cells in co...

Hi Peter, Generally you'd have the prior year data and current year data in the same table. You can then use calculated fields: Or if you're...

Hi Jismon, Welcome to our forum! I'm not aware of any way to fix this, sorry. It sounds like the table in the Excel worksheet was loaded to Power P...

Hi Mike, Welcome to our forum. I cover how to set up relationships for this in my Power Pivot course. The key is to create dimension tables for ...