BLOG
Category: Power Query
-
My favorite clean and simple way to combine csv files in Power BI
One of the unsung heroes to me in Power BI desktop (or Power Query in Excel) is how wonderfully simple it is to combine csv or Excel files from a folder. Maybe it’s not totally unsung, but I think it’s an everyday problem that many people have to deal with. It could easily be an entry point for many new users to see just how much easier Power Query can make their lives. As much as I appreciate how easy the tool allows us to automatically combine files without having to write any code, I never like all those extra…
-
Adding a row rank based on a different column with Power Query
Suppose you have two columns of data, one is something to group on and the other is something you could use to rank the rows. It might look something like this (grouping on Person, ranking based on Event Date): Now let’s say that you’d like to use Power Query to add a column that ranks each row based on Event Date, but groups it by Person, like this: To do this in the past, I have referred to Imke Feldman‘s response on this forum question more times than I can count. She has a wonderful little gif that shows exactly…
