Forum

Hi Mike, I sent your case to my fellow MVPs and Microsoft. So far I've had this reply form fellow MVP, Miguel Escobar: "That’s an interesting ca...

You can try using the DATE function to build the date inside the WEEKDAY function e.g. --(WEEKDAY(DATE(YEAR(L7),MONTH(L7),'HouseholdUsageData (kWh)...

Hi Claudia, Welcome to our forum. Please see file attached. Mynda

Hi Payal, The WEEKDAY function requires a date (serial number), you're providing it with a day of the month number. It cannot distinguish which day...

Hi Maureen, Welcome to our forum! Thanks for sharing your file. It's not clear who is entering the data or where the data is coming from. e.g. i...

Hi Mike, I'll ask Microsoft, but can you please confirm if how many rows and columns in your data set? And have you tried Get Data > From Dat...

Hi Mike, Welcome to our forum! Power Query is designed to fold queries back to the SQL server, however when you use your own SQL statement this ...

Hi David, Welcome to our forum! When you change the Slicer selection, what do you want Excel to do with the values you typed into the blue cells...

Hi Charmaine, I used an image editing tool e.g. Paint, to scale the image down to the size I wanted, which gave me the width in pixels. Mynda

Hi David, Sorry for the slow reply. If you edit the query in the file I attached you can see the steps I took. If you're completely new to Power...

Hi Angela, Sorry for the slow reply. Your workbook isn't attached. Can you please upload it again? Mynda

Thanks for your kind words, Tyler 🙂

Hi Mario, Welcome to our forum! This is probably a job for Power Pivot, but it's difficult to tell from the data above. Please provide a sample Exc...

Hi Grace, You need to write a measure that filters the result for the year you want. e.g. =CALCULATE(SUM(Table[Column]), DimDate[Date]=2018) ...

Hi Scotty, If you have Excel 2013 or later you can use Slicers with Tables for filtering. You can then turn off the Filter buttons on the Table hea...