Forum

No worries, Phil

Hi Alan, So the end result would look like this? Description Amount SumColumn 1001 150 600 1001 200 600 1001 250 60...

You're welcome. Phil

Hi Serghei, Try this in a new column List.Sum(let _Acc = [Account] in Table.SelectRows(#"Changed Type", each [Description] = _Acc)[Amount]) S...

Hi Paul, No file atatched. regards Phil

This article explains the new Array Shaping Functions Regards Phil

Hi Alan, See attached file. When I was doing this I was getting a problem (bug?) with List.Numbers. The idea is to create a list of x numbers w...

Hi Rahul, You can do this in Power Query with this code which you'll find in the attached file. NOTE the column containing the 'numbers' must be t...

Hi, No file attached. Phil

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...

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...

Hi Michael, no file is attached. Regards Phil

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

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...

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...