Forum

Hi Pam, It may be that the version of Power Query needs updating. Uninstalling and reinstalling doesn't necessarily mean the latest updates have be...

Hi Karen, There are several date fields in the sample file, I don't know which one you're working with or how you've tried to parse the data. Pleas...

Hi Jenn, Sorry, I don't understand. You said "I want to put that parameter where you have the 31." Where who has the 31? I can't see it in your exa...

Hi Irena, Please see the attached file. However, the sum of 95,608.13 relates to the table from 1number 201619038, not the number in table two; 963...

Hi, I'll answer this one here but in future can you please start a new thread for each new topic. PivotTables allow you to type a new value in a...

Hi Jenn, To add a column containing the number 31 on every row, simply go to Add Column > Custom Column > enter =31 > press OK. Alterna...

Hi Pakamon, What version of Excel are you using? If you have Excel 2010 you need to download the add-in. Versions from 2013 onward come with Power ...

Hi Chad, Welcome to the forum! I've not used the Power BI starter kit, sorry. I'm not aware of any alternatives to it either. Not much help on y...

Hi Seokli, Click on the drop down list for 'Name' and select the calculated item from the list, then press the Delete button in the dialog box. ...

Hi Tex, Welcome to our forum. I think this post on spreading income or costs over months will point you in the right direction. Please let us know ...

Hi Lee, Welcome to our forum. I'm not sure a query is what you need, unless the source data for your dashboard needs fetching from another sourc...

Hi D, When you Merge tables it doesn't add the rows directly below the first table. That would be an Append. A merge will match rows where possible...

Hi Gary, The course videos are available to download 31 days into your membership. The 'Download' buttons will light up on your My Courses page. If...

Hi Rebel, Thanks for providing the example file. It's clear now that you need a SUMIF formula. See file attached. Mynda

Ah, yes, I didn't spread the quarterly payments, but your solution is perfect. Glad we got there together in the end 🙂