Last seen: Apr 19, 2025
Glad you found a solution, David. Please let us know if we can help in the future.
Hi Douglas, Did you set the data type for the DateTime column in Power Query to DateTime? Keep in mind that the date types in Power Query are no...
Hi Danielle, Please upload a sample Excel file with a small dataset that illustrates the scenarios and your measure in a PivotTable that returns no...
You're welcome, Ian. Keep working through the course and it will become clearer
Hi Jennifer, You can't really do this with a Slicer because you'd have to refresh the PivotTable after changing the date you want to filter for. ...
Hi Ian, You need to create a Calendar/Date table and create a relationship between your source data/fact table and the calendar table that includes...
Hi Brian, You should be able to use the COUNTDISTINCT function (session 9.05) to count the number of distinct customer IDs per week ending date. Pu...
The budget table already has a ROW for your salary and expenses. You simply change the row labels to suit your needs.
You can add a column in your source data table to convert the transactions into whatever currency you want to report in. If you have Microsoft 365,...
Hi Lynnette, Sorry I missed your question, so this reply is slower than I'd like. There's no ideal way to do this. This post offers a solution o...
Oops, sorry about that. Here is the correct link.
Hi Tracy, It won't be your laptop that's the problem. When slicers/filters remove series from the chart, the custom formatting is sometimes lost, w...
Hi Danielle, There's no SAMEPERIODLASTWEEK equivalent, but this post has a solution. The WEEKNUM function is explained here. If you can't wor...
Hi Andrew, I'd do this with Power Query. You can 'merge tables' and match people in your source data to the 130 job titles list and filter by date....
Hi Pam, Thanks for sharing your file. The best way to automate the aggregation of this data is with Power Query. This spreadsheet as it is will ...