I'm trying to convert a python script to be a Function for Power BI (Power Query M) the code below takes a list of coordinates (Lat, Long) and returns a central point for the list.

Here, below is the result of my thoughts function fxPossibleCombinations (t as table) as table => //Do not use for more then 19 stores if you want to get ResultTable in excel sheet due to rows limit in …

Jan 29, 2019 · From power bi changing the encoding of the json file to utf-8 (like in the image) i still get the same problem, but if i open it as text and change the encoding, importing it from power bi looks …

I am trying to pull out data from okta api. But it shows only 100 records. I want to fetch from more than one web page. According to okta api documentation,

I need to calculate a value sA1 that for the baseline year (2018) is different from all following years. Additionally, (here's my struggle) the value of sA1 is based on the value of sA2 from the previous …

According to this article, Power Query (Get & Transform) keeps track of everything you do with the data. The Query Editor records and labels each transformation, or step, you apply to the data.

Answers 0 Sign in to vote Table.AddColumn (#"Your Table", "result", each List.Sum ( { [Column 1], - [Column 2] } ), Currency.type) Maxim explains it very well in his blog: Correctly Sum Two Or More …

Oct 8, 2017 · The first step is to insert rows: If PrazoContrato = 3 anos (3 Years) so we have to have 3 rows for that ContractThe second step is about to insert new (6) columns on the right based in …

I am trying to figure out a way to query a list of Computers that shows their current Windows Update Setting for getting updates. I have found a bunch of existing scripts that shows the amount of …

I have a file server with a bunch of Shares and need to get/set Share perms and inventory stuff. I've looked at other threads on this forum but there seems to be more than one way to do it.