Forum

You can try Number.RandomBetween to generate numbers (result should be rounded as it may have decimals) Number.RandomBetween(10000000, 99999999) ...

Hi Jim, You can try this step: = Table.TransformColumns(Source,{{"meeting_dates", each Text.Combine(List.Accumulate(Text.Split(_,",...

Hi Thomas, Try filtering the ManagerName column, in the column filter menu select Label Filters>Less Than, you will be able to filter the ManagerN...

Hi Giovanni, Try this query: let Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content], #"Added Custom" = Table...

Hi Nawaf, If you just want to see the results for a specific ID, you can just use a pivot table and a slicer for ID: If you want to process ...

The answer should be here:

Salut Dana, this: "sp_report ProfitAndLossDetail show TxnType_Title, Date_Title, RefNumber_Title, Name_Title, Memo_Title, ClearedStatus_Title, S...

Hi Brandon, I think you can use a grouping on the columns you want, then just add an index column to the grouped table. Because the Recorded column...

Hi Steven, Please upload a sample file with your data structure and a manual example of the expected result, will be much easier to help you.

Hi Jess, Why not duplicate the query, run the copy to see the changes, and run the main query only if you still want to run it.

Hi Aqsa, There is no file attached, make sure you press the Start Upload button after you Add Files. Anyway, screenshots will not say much, ther...

Hi David, Have you seen this article about CUBE functions? You can find a few examples here:

Hi Shannon, Can you please upload a sample file with data and an example of the expected results? Will be much easier to help you. Make sure ...

Hi Doug, You can try: try Function(xpath1) otherwise Function(xpath2)

Hi, Never seen this error personally, but I think it might be related to TLS 1.2 not being enabled (TLS 1.1 is no longer supported) This link sh...