Last seen: Jun 30, 2026
Hi Brent, It sounds like you haven't used a date field and then grouped them into months. When you use a proper date field and then grouping, the P...
It looks like your data isn't in the correct tabular format to support a Slicer that contains Room 1, Kitchen, Living Room etc. My guess is you have a...
In Excel when I import a file containing dates formatted as mm/dd/yyyy, let's say it's a text file, it will try to use my default date format (dd/mm/y...
Hi Gayle, I recommend you write explicit measures for each component you need to calculate. You can then check the results for each component are a...
Hi Ed, Did you change the date format for the Date column of the Dates table to m/d/y? In my file I have set the data type to Date and the date for...
Hi Joyce, If there are blank cells in the column/field you want to count then the count will not include those lines. If you want to count the numb...
Hi Mary, You can use the if statement to add a custom column for the fiscal quarters. For example, in Australia our financial year runs from July to ...
Hi Martha, The general rule is if you need to add calculated columns then you should use Power Query to do this as it's more efficient, whereas if ...
Hi Martha, I'm not aware of any performance benefits to importing CSV vs Excel files, however you may notice a smaller file size for the CSV's so t...
Hi Martha, If you rename a column in your query that has already been loaded into Power Pivot then you'll get that error because they column names ...
Hi Martha, Please watch the tutorial for importing files from a folder again because the second half of the video deals with importing Excel files,...
Hi Rusty, It looks like no one has experience with poly-whats-its, sorry. Unfortunately I don't either, but maybe my reply will bring your topic to...
🙂 I'll have to make them more exciting then!
Hi Bill, Yes, you can reference another query in a query. See session 4.19 for instructions on how to do this. Kind regards, Mynda
Hi Mike, I haven't tested as it's tricky without your data, but I don't think you can create this as a combo Pivot chart. Plus Pivot charts are bug...