Forum

Hi Filipa, I can't really tell what the issue is from the image, but a relationship will be inactive by default if you already have an active relat...

Hi Paul, I would use 'Add column from examples' and then give it a few examples for text with and without the hyphen. That should be enough for it ...

Hi Matthew, I didn't create the dataset, but it's quite common in the real world to budget for something that doesn't happen, or have new expenses ...

Hi Jig, Please see this tutorial: working with time in Excel. Under the heading: Shift Work Timesheets and Overtime If you're still stuck, pleas...

No. The data validation list source field does not accept formulas.

Hi Brett, The file isn't attached. Please click the yellow 'start upload' button after selecting your file and then wait for the grey check mark be...

Hi Kirtiraj, Please start a new thread with specific information about your query. Please address it generally as I may not be the one to answer it...

Hi Richard, The reason you're seeing 04-Apr is because the dates have been grouped by the PivotTable. If you right-click one of the dates in the Pi...

Hi Dieneba, DAX functions enable you to create measures and calculated columns on data in Power Pivot/Data Model. To do this with a regular Excel f...

Currently, the only way to access data from a query is to load it to a cell in the worksheet, or load it to a PivotTable or the Data Model. You cannot...

Hi Keith, If you've already loaded the query, then you don't have the option to change the 'to' from the query editor. However, if you open the Que...

Hi Brett, Map charts require you to summarise the data into states or countries. You can do this with a PivotTable and then build a regular chart f...

Hi Deirdre, If you make the chart small enough, the labels will automatically wrap., but they are also centered and there's nothing you can do abou...

Hi Wesley, If you wanted to reference anything outside of Power Query, you have to load it to the worksheet. If the average score is something you ...

Hi Jay, Depending on the version of MYOB that you have, there are some connectors available: - Power BI Odata connector - MYOB Advanced Conne...