Forum

Hi Prasanthsk, Why are you still insisting on using INDEX & MATCH for this task? SUMIFS/SUMPRODUCT is the correct approach. INDEX & MATCH or...

Ah, yes, the US date format in the survey is a pain. The only suggestion I have is to ask them to input the day, month and year in separate fields and...

You don't have to format the data in a table. You can bring in a named range or a sheet, but your data is too messy to be able to bring in every file ...

Ok. When you come back to it I think you'll need to create a mock-up of the data so we can see your question in context.

Thanks for clarifying, Ed. Does the server that has the Gateway have permission to access to the SharePoint directory that contains the CSV file? ...

Hi Bax, There are probably loads of ways to tackle this. In the attached file I've created 3 queries; the first captures the header information the...

Hi Frans, Your last comment sounds like you're getting close to what the problem may be, which is what I suspected initially. When you insert a ...

Hi Frans, I suspect your GETPIVOTDATA formula has a filter that remains for the "Yes" value, but difficult to tell without seeing the file, or at l...

Hi Ed, That UserVoice post is referring to the Enterprise gateway. The post linked to below on the personal gateway specifically cites an exam...

Hi Ed, I'm not aware of combining on-premises and online data sources being a problem. I know that when you combine sources (online and on-prem) yo...

Hi Moavu, In future please start a new thread for a new question. In the file attached you'll see the steps required in the query on the sheet c...

Hi Jørgen, Only testing will tell if it will work for you or not once you load your model into Power BI. I don't have any cube formula measures I c...

Hi Jørgen, You can create Sparklines with the custom visual from OkViz: You can use measures in your Sparklines, but I'm not sure if you have som...

Hi Michelle, With the pp_3_returns.txt file did you choose the 'Tab' column separator in the 'Table Import Wizard'? If you're still having probl...

Hi David, In session 1.03 I point out the menu difference in Excel 2016, sorry you missed that. The menus actually aren't that different, it's just...