Format a set of records which contains List & Records both RRS feed

  • Question

  • Hi Experts!!

    I am new to Power M query Language and trying to form a table ( to use under my visualization) from the following set of data:

    JSON structure is as follows:

     "result": [
            "stats": {
              "count": "29"
            "groupby_fields": [
                "field": "caller_id.location.u_region",
                "value": ""
                "field": "priority",
                "value": "1"

    and more data........

    Please help me in creating a table with only 3 fields: <count>,<region> and <priority>

    My assumption not to use DAX is that we format columns and create new measures using DAX once we have the data in Table format. Please correct me if I am wrong here!!

    Thursday, March 28, 2019 1:07 PM


  • Hi Anubhav,

    please provide a valid JSON-statement that contain data of at least 2 rows of your desired table.


    Imke Feldmann - MVP Data Platform (PowerBI) - http://www.TheBIccountant.com 

    Please use the 'Mark as answer' link to mark a post that answers your question. If you find a reply helpful, please remember to vote it as helpful - Thanks!

    Thursday, March 28, 2019 7:53 PM