Forum

Hi Steve, 1. if you want all departments then don't include a parameter for department. Simply remove column H from the table in my example. 2. ...

Hi Bill, Thanks for sharing your data. You will have to clean one class at a time because the original data layout is not consistent i.e. the numbe...

Hi Steve, If you're using Power Query to get your data from your SQL DB and load it into Power Pivot, which you should be, then you can use a param...

Hi Pamela, I'm not familiar with printing problems with Slicers. I did some Google searches and couldn't find any mention of this either. Instea...

Hi Hasnat, You can also use the list generator shortcut of two dots .. with Number.From to generate the list of dates using this M code: let ...

Hi William, Firstly, I've moved your question to our Power Query Members forum. The forums at the top are for non-members. Session 3.04 of the P...

Hi Mey, Unfortunately the 'All Data' worksheet is not in the ideal layout for working with the built in tools that make this task easy e.g. Slicers...

Hi Hasnat, The StackOverflow solution is for getting a file path. It does not work with dates. Your solution, or mine is fine. Many steps doesn'...

Hi Hasnat, In the attached file I've given the dates the following named ranges: StartDate EndDate 1. Create a blank query and used the =E...

I'd say it's just out of date documentation on that page. I'm not aware of any official mention that Windows 10 doesn't support Power Query. Anyhow...

Hi Chad, What makes you think you don't have Power Query in Excel 2016 on Windows 10? I have that setup and I have Power Query. Could it be that...

Hi Theresa, If they're PivotCharts then this is a known bug i.e. PivotCharts lose formatting upon refresh (sometimes!). That said, I don't recom...

I suspect so, but wanted to check if that could be the cause before I go back to Microsoft and ask. I'll see what I can find out.

Hi Amber, Add your calculated column to Table two. This is your fact table with the transactions. You need to classify each transaction into when i...

Hi Tony, What version of Excel are you using? Mynda