Hi, I believe I have solved the problem. The solution that did the trick was not a calculated column, but a Power Query column. Thanks to Mynda Treacy from Myonlinetraininghub for this example: https://www.myonlinetraininghub.com/quickly-create-running-totals-in-power-query ...
Hi, I have searched in wain for similar problems, but in wain. I have this table: Title Investment Return a 100 600 b 500 2000 c 300 3000 d 150 1500 e 250 2250 I need a calculated ...
OK... by picking the intervals between the numbers, I could see that all results were divisible by 24. 24hrs!!! Multiply the 0,817847222 by 24 and we get 19.62833. Multiply any of the decimals by 24 and subtract the constant 0.62833 and you get the ...
Hi Importing a csv that was created via the Nordea statement "Download CSV" there is a challenge with the date format. You will see on the attached extract that the March dates are in a useable format. However the April date area converted to decimal, ...
Hi Bobby You are right. It is working perfect. It was a syntax mistake we made. Here it is with a PriceArea: Kilde = Json.Document(Web.Contents("api.energidataservice.dk/datastore_search_sql?" & "sql=SELECT * FROM elspotprices WHERE ""HourDK"" > ...