March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
I don't want to continue creating more JsonX variable and then putting each one in the combined list
let ....
#"Json0" = Json.Document(#"Expanded logs"{0}[logs.Content],1252),
#"Json1" = Json.Document(#"Expanded logs"{1}[logs.Content],1252),
#"Json2" = Json.Document(#"Expanded logs"{2}[logs.Content],1252)
#"Combined" = List.Combine({#"Json0", #"Json1", #"Json2"})
in
#"Combined"
You probably want to use List.Accumulate. It is a pretty complex function, so I recommend you google for some tutorials on it or check out this article.
It should do what you need. You may need to check out List.Generate as well. Equally as complex, but may be needed to generate those numbers you are using as an index in the brackets. Again, do some googling for articles or online videos.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI Reporting