Last seen: May 23, 2025
Hi Mattias, It's probably ok to use the many to many relationship, but you'd want to do some spot checks to ensure it's reporting the results corre...
Hi Marko, Thanks for sharing your file. There is an easier way. Simply right-click an of the values in the PivotTable > Show Values As > Diff...
It's a side effect of using a PivotTable as the source for a pie chart when you have multiple axis labels/expandable fields. I'd try showing your boss...
Hi Mattias, In Power Query the process is the same except you use the #date function e.g.: =#date(year, month, day) Note: the formatting shou...
Hi Melissa, I appreciate it's not easy to follow written instructions. To clarify, I said: "After you unpivot it in Power Query, you 'close & l...
Hi Misha, Can I suggest you use a bar chart instead of a pie chart. You should never show more than 3 segments in a pie chart. Any more than that a...
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...