Forum

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.

Hi James, Add a Semester column in Student Results table with this formula: =IF(OR([@Quarter]="Q1",[@Quarter]="Q2"), 1,2) Then, instead of re...