Forum

Philip Treacy
Philip Treacy
@philipt
Admin
Member
Joined: Oct 5, 2010
Last seen: Aug 18, 2025
Topics: 61 / Replies: 1579
Reply
RE: Calculate rolling average in power query

Hi Andy, There are a few ways to do it but the easiest would be to add an Index column starting from 1, then use List.FirstN to get the items in th...

2 years ago
Forum
Reply
RE: Automatic assign team members to projects

Hi Vinh, Can you please supply a file with sample data so we don't have to recreate it and perhaps make mistakes with the table layouts. Regards...

2 years ago
Forum
Reply
RE: Dates Formatted as Text with Power Query Conversion Fails

Hi Michael, no file is attached. Regards Phil

2 years ago
Reply
RE: Multiple V & H lookup in 2010

Hi Paul, Can't really help you without some data to work with and an explanation of what result(s) you want. regards Phil

2 years ago
Reply
RE: Simple string body to display in an email

Hi Roger, You haven't actually said what the problem is, and any error that VBA generated would assist in finding the issue. However after runni...

2 years ago
Forum
Reply
RE: number coloring positive green negative red in card visual in power bi

Hi, I wrote about this topic here Conditional Formatting in Power BI You can do this 2 ways: 1) Using formatting based on rules 2) Using f...

2 years ago
Reply
RE: Running Balance based on difference of 2 rows plus the previous row.

Hi John, This isn't your typical Running Total so the code I wrote for Power Query Running Totals would not work without modification. So, I've ...

2 years ago
Forum
Topic
Forum
Replies: 2
Views: 166
Reply
RE: Automatic filtering for different files that will save a lot of work time

Hi Leah, Really difficult to give you anything other than generic advice without seeing an example of the data, and specific instructions on what d...

2 years ago
Reply
RE: Add Column - Extract From Text

Hi Steven, If you can supply the file, or at least a good representative sample of the data in a file, you'll find you get a quicker response. If ...

2 years ago
Forum
Reply
RE: VBA Error with Real Time Data

Hi Goran, Your file isn't attached, only a screenshot. I can't quite make out the wording in the screenshot but it's a VBA error. Unless I can ...

2 years ago
Forum
Reply
RE: How to add a new query for each cell of a column

Hi Mohamed, I watched the whole video and I think what you want to do is find a quick way of duplicating a query? In the video you right click t...

2 years ago
Forum
Reply
RE: Calculate occurrences of max value by hour

Nothing attached. Click Start Upload after selecting the file.

2 years ago
Reply
RE: Running total in power query

If you actually try to provide detail about what it is and explain clearly the result you want, it'll be much easier to help you. To start, in your...

2 years ago
Forum
Page 8 / 110