Showing posts with label Power Query. Show all posts
Showing posts with label Power Query. Show all posts
Thursday, 24 July 2025

Excel's yellow triangles when imports matches no exports

›
  If you've ever seen a yellow triangle here the chances are it might have taken you a while to fix it. When I asked Co-Pilot it was use...
Wednesday, 13 November 2024

Replacing values in Power BI revisited

›
Back in 2022 I wrote a post detailing the various ways you can replace part of a string in M code (Power Query). It's actually the post...
Thursday, 19 October 2023

Vlookups in Power Query (for power BI)

›
If you're familiar with Excel before moving to Power Query then it's a little maddening to find that PowerQuery doesn't have a b...
Friday, 28 October 2022

Add extra rows in Power Query dependent on value in cell/column

›
If you're working in Power Query, and you need to add a whole bunch of blank rows, or rows based on the value from another column. How d...
Thursday, 20 October 2022

How do you sum a total for a column in Power Query?

›
Power Query has a "Count Rows" button, but there's no equivalent button for when you want to quickly get the total of your val...
Wednesday, 25 May 2022

Joining/Merging Columns in a single step

›
As per my previous post sometimes, for tidiness you just want to do something in a single step. So how do you do this with merging / joining...

Remove/Replacing part of a string in Power Query

›
If you like keeping things neat and understandable in Power BI then you probably like to minimise things to one line. So there are times whe...