Forum

Hi and welcome to our forum. This doesn't sound like a tabular data set, which is what Power Query is designed to do. Are you wanting to add 'Summe...

Hi James, Power BI is a moving target of constant changes! I'll have to re-record that tutorial. Put the value field in Tooltips and then in the...

Hi Michael, There are two ways to reference a file on OneDrive; one is referencing the file in the synced folder on your hard drive or a network dr...

Hi Brian, Thanks for sharing your workbook. Velouria's response above is the culprit. Mynda

Hi Shawn, I don't recommend separating your data into a tab for each month. Excel functions and PivotTables are designed to work with data in one t...

Hi Michael, Are you wanting people to be able to refresh the query or just interact with the dashboard e.g. make selections in Slicers and filters ...

Hi Brian, Welcome to our forum! Is the cell font colour formatted to the same colour as the cell? Is there Conditional Formatting applied to the...

Hi Gary, That sounds awful and frustrating no doubt. I've not heard of this issue before, but I wonder if an add-in, maybe in Excel or anther app o...

Hi Brian, There's no difference/benefit. You could equally write the formula this way: =INDEX(TblDV[Month],C1) I have the first column in the...

Hi Oot, Thanks for the further info. It's still not completely clear. e.g. Column F is also <> 0 but you didn't mention it in your "i got res...

Hi Eric, Welcome to our forum! You need to structure your data in a Tabular layout. When you structure your data this way the formulas are easie...

Hi Rajiv, Power Query loads to a table in the file containing the query, or to the data model in the file containing the query. You can't load it t...

Hi Alison, You can use this technique to reference the next row in Power Query. You'll want to bring the ReportData date column in again so you can...

Hi Aye, No, you need to number grouped data then merge the queries. See attached. Mynda

The suggestion is to remove the 2 extra sales so each sales person only has one sale for the purpose of the merge. If you provide a sample file I'll s...