Forum

Hi Raghav, Welcome to our forum. It's great to see you're trying to rebuild the dashboard. Please share a screenshot of your measure formula, t...

Not sure why you can't open the file in Excel 2016. There's nothing special in there as far as I recall. Here are the queries: This is the transpos...

Hi Craig, Power Query uses IE to access web pages. Have you tried opening the web page in the IE browser and then clicking the Accept button? Once ...

Hi Amien, It's not identical to your examples, but it's close. Hope it helps. Mynda

Hi Michael, That's a tricky one because for every product you need 3 sets of data, two of which are plotted in the chart. It would be easy if it wa...

Hi Robert, Chris' solution converts the times to text which will render them useless in formulas when you Close & Load. This may not be a probl...

Hi Robert, Have you set the data type for the InDate - Copy.1 column as date before trying to extract the Month number? Mynda

Hi Francis, You don't have BBB-1 in your Type table, this is why there is a '(Blank)' Name in the PivotTable in columns O:Q. Mynda

Hi Laura, Presumably the States Visited with be another question, so you'd need that information in the Responses column. If you 'unpviot other col...

Hi Francis, Please provide a sample file. My imagination isn't that good 🙂 Mynda

Hi Tracy, No, it doesn't look like you can format the selected item buttons. Only the non-selected items, which seems silly. You could try looking ...

Hi Laura, Yes. Follow the Power Query lesson 2.05 Get data from a folder to see which query you should be performing the unpivot in so that any new...

You can't really do this with a formula as there's no consistent pattern, but you can use Power Query, see example file attached. Note: can you ple...

Hi Reehan, Please also explain the problem in the thread so that others know what the problem is before downloading the file and the question and s...

That makes sense if your actual data doesn't have anything on the last day of the month. Thanks for sharing.