Forum

Hi Marko, If you have proper dates in your model, which you should, then you can use the time intelligence functions like SAMEPERIODLASTYEAR etc. t...

Hi Rick, Sorry about that. I've fixed it now. Mynda

Hi Peter, This is a job for Power Query. If your data is messy you can automate the cleaning of it before the matching steps. Mynda

Hi Bax, You can use Group by to get the total sales by region and customer. And then you can number the grouped data, and lastly filter it to only ...

Looks like you have a 'Total' in your source data because totals calculated by the PivotTable do not display in Pivot Charts. You should never have to...

Hi Lauren, It's great to hear you and your team are making use of your new skills! One of the main reasons we don't use fact tables as proxy dim...

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.