Forum

Glad you figured it out, Jan 🙂

Hi Maarten, I can't see any obvious issues with the first PivotTable in the Week tab. If there is something still not right with this please provid...

Hi Lakshmipathi, The purpose of the forum is to help you with specific Excel questions and troubleshooting. 'How to build a dashboard' is too broad...

Hi Peter, What happens if you create two queries in one file and then merge/append the two queries? Mynda

Hi Alex, With Pivot Charts this isn't possible, but you could use a regular chart to plot each category as a different series and then format each ...

Hi Maarten, Great to see you're making progress. As for the hierarchy issue, I can't see what the problem is. "the Year/Week-hierarchy appears t...

Hi Maarten, If you get files from a SharePoint list you can then combine them and then in the Query Editor go to the 'Transform Sample File' query ...

Hi Michael, Welcome to our forum! You can use a Power Pivot PivotTable to perform a distinct count on the date field per customer. See file atta...

Glad I could help 🙂

Hi Vicky, If you get the data with Power Query you are doing the cleaning before the data gets to the Power BI model. i.e. it doesn't matter if you...

Hi Vicky, You need to use a lookup table when your periods are not in line with the calendar months, as explained here. Mynda

Hi Trevor, Go to the View tab in the Power Query Editor > Query Dependencies. Hope that's what you want. Note: only available in 365 versions of...

Hi Vicky, Queries in Excel will only refresh if Excel is open. If you're building a Power BI report, I recommend you move the query to Power BI,...

Thanks so much for sharing, Jim! Shorter is always nicer 🙂 ...as long as it's not slower of course.

Hi MJ, Welcome to our forum! A budget vs actual formula should be quite simple: = SUM([budgeted chemical cost %]) - [actual chemical cost %] ...