Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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