Forum

Hi Paul, See workbook attached - Sheet2. It contains a PivotTable with the straight averages and running totals. Note: the running totals are based...

Hi Chad, Thanks for clarifying. I think it will be down to the 32-bit limitation on your version of Excel. Is the Excel file containing the 1.04...

Hi Bill, Sorry, I forgot to point out that the Shape Maps are currently in Preview so you need to enable them in the Power BI Options: ...

Ah, yes sorry. I left out the 'current' part of the function 🙂 Glad you figured it out. Mynda

Hi Chad, Can you please clarify a couple of points: 1. When you load the data into the Power Pivot model are you loading data from workbook A in...

Hi Susanne, The good news is you don't need to have a Power BI account to download the Power BI Desktop software. Just close the window that asks y...

Hi Chad, When you imported the Excel data did you open the Excel file containing the data and then load to Power Query and Power Pivot all from wit...

That's a shame, Ewan. I'm not aware of Citrix performance being affected by Power Query. You might want to do some Google searches for evidence around...

Hi Nuja, Format your Excel data in a Table. Note: make sure when you create the Table from your data in Excel that you do not check the 'My data ha...

Hi Jon, Yes, you can write a DAX formula to do this. This post has some DAX patters for time calculations: I hope that points you in the right ...

Hi Mary, It appears to be a bug. I wasn't able to look at the query because I don't know your Salesforce login, but I was able to copy the Account ...

You can use the Excel.Workbook function in a blank query. In the formula bar type: =Excel.Workbook() Press enter.

Hi Fabiana, Thanks for sharing the images but they're really too small to make sense of. In future please take a screenshot as opposed to a photo o...

Hi Oleg, Correct, the customize options in Power BI are still quite limited. The only lines you can change to a different style are the Constant li...

Hi Digalo, Yes, if you use From File > From Excel you can bring all of the sheets/tables/named ranges in, in one go. Make sure you check the 'Se...