Forum

Hi Aye, The fiscal year column isn't a date, it's just a number; 2018. If you try to set it as a data type of date it returns the year 1905 because...

Hi Mardi, This video explains how you can use a mapping table to bulk replace the parts of the address you want to remove: Mynda

Hi Tracy, I couldn't find any queries called "UniqueStations". You also said 'I amended the media owner', what do you mean by amended? What exactly...

Hi Rick, TBH I've not tried Power Query with a .xltm file. You could give it a go. For easy updating of the source file, you can use a parameter...

Hi Allison, You can download the files from the Power Query syllabus page. There is a link at the top that says 'download course files'. Please let...

Sounds like a good plan, Rick. Set up your first Excel file that uses Power Query to get the source data from the day1 file and load it into Power Piv...

Hi Dick, No file attached. You have to press the yellow 'start upload' button to complete attaching the file. Mynda

There haven't been any changes in Excel that would result in a file size reduction so it may be a Windows change.

Hi Anne, For demo purposes you could create a neighbourhood hierarchy which would give you a reason to have a dim table. e.g. Nova Palestina and Co...

Hi Katrina, You can just discard the second header row and rename the columns after cleaning the data. See attached. Mynda

Hi Katrina, Can you please upload a sample Excel file containing your before data and desired result. It's very difficult to help you from the scre...

Hi Anne, I can't see any benefit to creating a neighbourhood table since there is only one column containing this data. If there were multiple c...

Hi Katrina, If they're merged cells then once you format the data in an Excel table for loading to Power Query the rows will un-merge. Have you tri...

Hi Michlus, If you load your data into the Data Model you can add a column to your table and use 'Sort by' on the Home tab of the Power Pivot windo...

Hi Ken, Yes, you can unpivot the data. First remove the blank rows in column1, then add an index column. Convert the Index to Modulo and Pivot base...