Forum

Mynda Treacy
@mynda
Admin
Member
Joined: Jul 16, 2010
Last seen: Jun 14, 2025
Topics: 0 / Replies: 4765
Reply
RE: Trendline in Power BI visuals

Hi Petek, Select the visual, go to the Format tab > under the Visual options there's 'Trend line'. See image attached: Mynda

11 months ago
Reply
RE: Importing Text Files to Power Pivot does not work

Hi Linlin, Apologies for the slow reply. You posted your question in the public Power Pivot forum, so I didn't see it right away. I've moved it to ...

11 months ago
Forum
Reply
RE: Not Sure VlookUP | XLookUP | Filter | INDEX MATCH

Hi Pam, You can easily automate all of this with Power Query. Including the initial task of extracting the 40k rows of PA data. Then any new data o...

11 months ago
Reply
RE: LET Formula

Hi Rodney, mon1 is considered a cell reference. e.g. if you CTRL+G and enter MON1, you'll be taken to column MON. Try changing mon1 to mon_1 and...

11 months ago
Reply
RE: Calculate Same Period Last Week and % Change

It returns blank in a card because the card has no row context for the 'Date'. i.e. it doesn't know what the date is that it should be based on. I...

12 months ago
Forum
Reply
RE: merging 2 sheets with data structured differently

Rename the columns before appending so they match and then Power Query will know they are the same.

12 months ago
Forum
Reply
RE: Pivot table connects to wrong power pivot model

That's ok. You can download the data to one Excel file and then connect to that file with Power Query from a separate file to bring the data into the ...

12 months ago
Forum
Reply
RE: merging 2 sheets with data structured differently

Hi Gosia, You can append them and any columns that don't match will be empty for one dataset and vice versa. Mynda

12 months ago
Forum
Reply
RE: Pivot table connects to wrong power pivot model

Power Query offers a more efficient method for loading data into Power Pivot. If you load data already present in your Excel workbook into the Power P...

12 months ago
Forum
Reply
RE: Pivot table connects to wrong power pivot model

In theory, you should be able to save a copy of the file or rename the file and the queries and data model and connected PivotTables all relate to the...

12 months ago
Forum
Reply
RE: Pivot table connects to wrong power pivot model

Hi Linda, Glad you found a solution. I expect that your old PivotTables would need to be deleted to get rid of the connection to the old data mo...

12 months ago
Forum
Reply
RE: removing duplicates

Hi Gosia, You could add a column that converts the values in the Price Sold column to contain all positive values, let's call this column 'Value'. ...

12 months ago
Forum
Reply
RE: Calculate Same Period Last Week and % Change

Hi Danielle, Thanks for clarifying. When working with averages it doesn't make sense to subtract one period's values from another. In the file ...

12 months ago
Forum
Reply
RE: Calculate Same Period Last Week and % Change

Hi Danielle, Why are you dividing it by 86400? The source data already contains the average queue answer time, then the measure averages those valu...

12 months ago
Forum
Reply
RE: Importing text file in power pivot data model 3.06

Hi Shruti, Please see the comment/note below the video for that lesson. Mynda

12 months ago
Forum
Page 4 / 318