Forum

Hi Beth, You need 4 separate queries here, one for each scenario. The join type will differ depending on the scenario. Have you seen this post whic...

Hi Daniel, Welcome to our forum. In future please be sure to only post your question in one place so that people don't waste time answering questio...

Hi Donna, Welcome to our forum! Your file name contains a percentage sign which prevents it being downloadable by people viewing your question, whi...

Hi Mattias, You should put your fiscal periods in your date table without the times. You may also need this information in your date table with tim...

Thanks for sharing the file, Rick. The date is entered correctly. There shouldn't be any spare/blank rows in the table. This is what's causing the bla...

Hi Rick, Welcome to our forum! Please share your file so we can see what is going on. It looks like the date format in your transactions tab might ...

Hi Max, I think your table is fine and you can enhance the filtering functionality with Slicers for Excel Tables. To fix the count information, you...

Hi Mattias, As Phil said, seeing your file would be easier. It looks as though you have a record in the source data table with no day name or time ...

You can't do this with this technique. If you add a filter (Slicer) for the year it will override the filter on the 'Include Years' column in the Pivo...

Hi Shawn, Please see this tutorial on how to calculate if dates fall between a date range. Mynda

Hi Mark, PivotTables sort by the first column. If you want to sort by date, put the date field in the first column of the PivotTable row labels. ...

Great to hear! Thanks for letting us know.

Hi Chris, Welcome to our forum! You can change the starting date formula to something more relevant to you. If you want the previous week and th...

Hi, please see an example file attached with a possible solution. Mynda

Hi Scott, Given that the position of the codes can be left, middle or right, I think you need to split the data into rows so you can compare them m...