Forum

Hi Mattias, You need to add a column using the DATE function and rebuild the date using the year, month and day values e.g.: =DATE([Calendar Yea...

Hi Yuan, With a Microsoft 365 account you can use the new change tracking tool. Mynda

If you've got your data in a tabular layout then you can go ahead and create the PivotTables. You can add new responses to the original source data ta...

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