Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 ReportingCovering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
100 | |
54 | |
21 | |
12 | |
11 |