Forum

Hi Alicia, You have to use column references instead of cell references: ActualLocation= if [AST.1]=[AST.2] then [AST.1] else if ([AST.1] ="BLAN...

Hi Rob, drill downs in power pivot measure might not always return results as expected, here is a problem description and a solution that should wo...

Hi Yuan, Referring to items in a table by position is very slow, PQ was not built for cell references. Instead, you should merge Adhoc2 with Adh...

Hi Simon, Here is a solution (incomplete, just the relevant steps): Table7Data = Table.ExpandTableColumn(#"Removed Other Columns", "Data", {"Col...

Actually, Power Query can send data to an api, but it might not work properly on all API's, as Anders mentioned it was built mainly for reading data, ...

You have to take a closer look at the source data, if the results are not as expected. If you look at AST.2 column, the names in that column have a...

That's what I mentioned above: you have to merge based on more column keys, as I did in the previous message sample file. I used Rep AND Code columns ...

Please share more details, an example of your wrong attempts will help. In Merge settings, you can associate more columns as keys, in the attached ...

Sorry, fixed the link in the previous post. The equivalent of Index-Match or VLOOKUP in Power Query is the Merge operation, it's much stronger and ...

Hi Alicia, You have here a good tutorial describing exactly your case:

Hi Mile, Depends on what you have in that sheet. If you have pivot tables, you have to use a method specific to them, same for tables. If you do...

I think the idea for this scenario is wrong, you should not split data. Anyway, power query does not split data, the main purpose of PQ is bringin...

At the end, I need to have 5 different tables. Not one table including 5 weeks, because that would be just the same table as the original fact table. ...

I added following text to the function code in order to accumulate the results: fx_FilterByWeek(tbl_flight_schedule, CurrentValue) Sorry, not see...

Most probably, you get the last loop value, because you are not accumulating the results. Here is an example of a recursive function: