Forum

Hi Trudy, Welcome to our forum! Please create a small mockup file with sample data that we can use to provide you with a solution. Please show the ...

Hi Jigar, This post has some ideas on how to speed up Power Query. It's obviously not the small file causing the issue, it's more likely the other ...

Can you share the Power BI file with me? Either here or email it if it contains confidential data - website @myonlinetraininghub.com Please ensure the...

If you don't need to ignore weekends then it's even easier. Just create a date table of consecutive dates. Merge the tables based on the date column a...

Hi Chris, If your dates are to be consecutive then you expect your employees to work everyday? I suspect you haven't been clear and what you really...

Hi Tan, You can't partially transpose a table, it's all or nothing. Please see my solution attached which requires adding 4 new columns to capture ...

Hi Chris, Thanks for the clear explanation. Referencing rows is notoriously slow. You can duplicate the query 3 times and insert an index with a st...

Hi Chris, Thanks for the file, but I'm not able to quickly understand how you're arriving at your desired result. Please provide further clear expl...

Hi Tan, Please re-watch session 2.05 Get files from a folder. Here I explain that when you need to make changes prior to appending the data, that t...

Hi Mariena, Try putting the date field in your quick measure table. Without context it will not calculate. i.e. it doesn't know what year to what y...

Hi Brandi, Power Query is definitely the best way to do this. You can use the Data tab > Get Data > From Excel File menu to get the data from...

Hi Thomas, I would abandon the Timeline Slicer and use a technique more like this Slicers for rolling periods technique. You can replace 'today's' ...

Hi Declan, You need to add the fiscal period fields/columns (for quarters & years) to your date/calendar table. It's most efficient if you use ...

Hi Daniel, The PivotTable shouldn't need manual sorting for dates. It should work as Phil explained. I looked at your file and there are some un...

I guarantee your Excel is working just fine. Please see screenshots attached for further examples.