Forum

Hi Danielle, Thanks for clarifying. When working with averages it doesn't make sense to subtract one period's values from another. In the file ...

Hi Danielle, Why are you dividing it by 86400? The source data already contains the average queue answer time, then the measure averages those valu...

Hi Shruti, Please see the comment/note below the video for that lesson. Mynda

Glad you figured it out. What version of Excel do you have? I ask because you're using the files from the 2010 to 2013 version of the course. If you h...

Hi Danielle, Thanks for the file. Please see file attached where I've focused on just one measure for the % Change v Prior Week Contacts Queued. ...

I'm a bit confused. To clarify, did the Date/Time column in Power Query had the Date/Time data type set? If so, it should feed through to Excel as a d...

Hi Douglas, You can edit the hard keyed reference to 'Weekday' with 'Column1' via the formula bar or advanced editor. That should fix the issue. ...

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.