Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Markzolotoy
Impactful Individual
Impactful Individual

Help with transforming Json data

I have the following json:

 

 

{
  "AgeDistributionWeeks": {
    "Week1": 1,
    "Week2": 0,
    "Week3": 0,
    "Week4": 0,
    "Week5": 0,
    "Week6+": 0
  },
  "CaseCategories": {
    "(Uncategorized)": 1
  },
  "CasePriorities": {
    "CasePriorityNormal": 1
  },
  "OpenCaseCount": 1
}

 

How would I transform it into something that I can create some charts based on it?

 

Thanks

1 ACCEPTED SOLUTION
lbendlin
Super User
Super User

This entirely depends on what the data means to you, which part is important, at what granularity level etc.

 

let
    Source = Json.Document(File.Contents("C:\Users\xxx\Downloads\test.json")),
    #"Converted to Table" = Record.ToTable(Source),
    Value = #"Converted to Table"{0}[Value],
    #"Converted to Table1" = Record.ToTable(Value)
in
    #"Converted to Table1"

This is just one example of how you can parse the content. 

View solution in original post

1 REPLY 1
lbendlin
Super User
Super User

This entirely depends on what the data means to you, which part is important, at what granularity level etc.

 

let
    Source = Json.Document(File.Contents("C:\Users\xxx\Downloads\test.json")),
    #"Converted to Table" = Record.ToTable(Source),
    Value = #"Converted to Table"{0}[Value],
    #"Converted to Table1" = Record.ToTable(Value)
in
    #"Converted to Table1"

This is just one example of how you can parse the content. 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.