Forum

Hi Simon, Great to hear you're making progress with the courses! In lesson 6.11 of the Power Query course I cover error trapping using try/other...

Hi Bax, The data model can't access custom lists, therefore you add a sort order to the data model and set the 'sort by' column in there. Mynda

Hi Lee, You can add another criteria to the AND formula for the green conditional format that checks the date and name against the days on site lis...

Hi Jennifer, The queries that are connection only don't make much difference to your file size at all since the data isn't getting loaded anywhere....

Hi Tania, The formula has too many parentheses, but that won't be causing the problem. Here's the same formula without the extra parentheses: =I...

Hi John, Welcome to our forum! Presumably the source file name is in a column. If so, you can simply use Replace to remove the .xlsx and then fo...

Hi Aye, You can use the OData link to connect Power BI to Xero. I'm not sure if the API will allow you to generate the trial balance at date int...

Hi Eileen, Power query isn't the right place to do a calculation like this. If you're using Power BI then you need to write measures that use th...

Hi Eileen, Your data is in the wrong format for a PivotTable. You shouldn't have a separate column for each month. You should have a column that co...

Hi Chris, Another option is to reference the PivotTable with formulas to recreate the source data where you can apply the number format you want. Y...

Hi Steven, Not sure why you aren't using Power Query to import the data. VBA is the old way to automate the gathering and cleaning of data. Mynd...

Hi Richard, Power BI doesn't allow you to input data and it uses the same Power Query tool as Excel, so this won't solve the problem, unfortunately...

Hi Chris, Thanks for sharing your file. If you want the chart to show every data point at the time level of detail, then the best you can do is nes...

Hi Vishnu, Please upload your file again. This time be sure to click the 'Start Upload' button and wait for the grey check mark beside the file siz...

Hi Fernanda, Please supply your file or a sample file so I can see what you mean. Mynda