Forum

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

Hi Sunny, This is either a credentials or permission error with the SQL server you're trying to connect to. You need to speak to your IT administra...

Hi Marciano, The Path Table technique only works with files saved on your PC or a local server. The file path in the image is a URL, which tells me...

Hi Robert, It appears to be caused by a change in 365. The file used to work and now with 365 it causes problems. There's a note under the video wh...