Forum

Mynda Treacy
@mynda
Admin
Member
Joined: Jul 16, 2010
Last seen: Aug 1, 2025
Topics: 0 / Replies: 4767
Reply
RE: Calculate Same Period Last Week and % Change

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

1 year ago
Forum
Reply
RE: Importing text file in power pivot data model 3.06

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

1 year ago
Forum
Reply
RE: Lesson 7.05 - File Error

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

1 year ago
Forum
Reply
RE: Calculate Same Period Last Week and % Change

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

1 year ago
Forum
Reply
RE: Lesson 6.05 Remove Column

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

1 year ago
Forum
Reply
RE: Lesson 7.05 - File Error

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

1 year ago
Forum
Reply
RE: Copy Group Box and Radio Buttons

Glad you found a solution, David. Please let us know if we can help in the future.

1 year ago
Reply
RE: Lesson 6.05 Remove Column

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

1 year ago
Forum
Reply
RE: Calculate Same Period Last Week and % Change

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

1 year ago
Forum
Reply
RE: New customer count

You're welcome, Ian. Keep working through the course and it will become clearer

1 year ago
Forum
Reply
RE: In Care Slicer or Time Line

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

1 year ago
Reply
RE: New customer count

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

1 year ago
Forum
Reply
RE: New customer count

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

1 year ago
Forum
Reply
RE: 2 Currencies using Mind's Personal Budget

The budget table already has a ROW for your salary and expenses. You simply change the row labels to suit your needs.

1 year ago
Reply
RE: 2 Currencies using Mind's Personal Budget

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

1 year ago
Page 5 / 318