Forum

Hi Greg, The syntax of Record.Field around the API call wasn't right. The "price" field name was in the wrong place. This works = Record.Fie...

Hi Greg, It's hard to help because I don't have the file and code that you are using. Can you make a copy of the file, change the API credentials ...

Hi Tina, There's no file attached with data to test this on so hard to say. If I use that formula in an empty workbook, that has a sheet called ...

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