Forum

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

Hi Steve, For best results please start a new thread with your question. You can link back to this question in your new post. Mynda

Hi Alexandra, Please try uploading your image again and also upload a sample file with your data so we can help you further. Mynda

Hi Pam, Please share your file so we can help you. Mynda

Instead of adding your labels as text boxes, use the data labels and reference the cells containing the label for each point. You can choose this in t...

Glad the workaround fixed it