Forum

Hi Christoph, Welcome to the forum 🙂 You can use Power Query (not Power Pivot) to get the data (Data tab of the ribbon) 'from Online Services'...

Hi Linda, Try =CALCULATE( DISTINCTCOUNT( FactTable[CustomerKey] ) , [LastTransactionDate] >= [LostDaysLimit] ) Mynda

Hi Robert, Please provide an Excel file containing your sample data before and how you'd like it to look. I can't tell if that data is in one cell ...

Hi Catherine, Firstly, congratulations on your success with Power Query. I'm so pleased I could help in some way, but you are the one who did the h...

Hi Catherine, Before you click on the double down arrow on the 'Content' column to combine the binary files, add a column with this formula: =Ex...

Hi Aye, What do you mean by a 'parameters page'? Do you mean the parameters that are available in Power Query, or do you mean a tool a bit like a S...

Did you try getting the new connection string as suggested in the post I linked to?

Hi Jim, Welcome to the forum! You might run into problems because Visual Foxpro is no longer supported. However, you can try getting the data wi...

Hi Mark, It's still in preview so not everyone will get it as they sometimes do A/B testing and only release to some users of the same build. Upgra...

Hi Anne, Updates for Power BI Desktop are released once a month. You don't have to download and update Power BI this often if you don't want to. It...

Hi Eric, Table and field names in Excel 2010 Power Pivot are super sensitive to change. Is it possible a table or column name has been changed or a...

🙂 glad I could help, Joe!

Hi Fidele, The map charts are plotted by Bing Maps, however it's not the full Bing map service and as a result we often find that smaller countries...

Hi Nick, Best to have a folder that only contains the workbooks you want to get data from. This should be easy enough for you to construct. Powe...

Hi Allison, The current layout is temporary. I plan to have separate courses for 2010/2013 and 2016 onward, but rather than making you wait for the...