Forum

What other types you have in mind? Should be easy to add new types in the list you mentioned, with any types you need.

Can you tell me why LB01AF_HSBC Maldives MOP is Non Accountable, even if it is located before the other 3 that are Accountable?

As an alternative, you can easily detect the last 2 columns using List.Select then using List.LastN, as in the example below for RevIncreaseCustomers....

I am not querying a folder, but file A, so the temporary "~"file should not be the issue? Instead of querying file a directly, start a query from...

Hi Vic Man, Is it FIFO method you are looking for? This topic might help you: Or:

Just another note: a P&L report is a complex subject. To create reports based on a chart of accounts multilevel hierarchy is a challenge, espec...

Hi mgbsher, For the type of analysis you want, you should really use Power Pivots, not calculated items/fields. Please refer to your other post...

Power BI has the same tools: Power Query and Power Pivot, however there are some functions in PBI not available in Excel. The source data should no...

Hi Vladislav, You can use this solution, with a YearMonth column added to the tables:

Hi, The last step in the query I provided wrongly refers to Fixed Assets instead of Total Assets as the denominator. The step should look like: ...

Hi mgbsher, Here is your query with a new custom step: let Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content], #"Changed Type" = Table...

Hi Anke, When you query file A, if it is open, the query will fail. There are 2 ways to avoid this: in power query, if a file is open, the quer...

Hi Lionel, Transform your file query into a function like this: (tbl as table)=> let //Source = Pdf.Tables(File.Contents("C:Users0060106Dow...

Hi Goran, Welcome to our forum. Please use google translate to understand each other easily. Greetings! I need a formula that will autom...

Hi Ritender, As an example, I reformatted the source table in a proper tabular format. See the file attached.