New features for the Power BI Dataset API

social default image New features for the Power BI Dataset API

{

  “name”: “PushAdvanced”,

  “tables”: [

    {

      “name”: “Date”,

      “columns”: [

        {

          “name”: “Date”,

          “dataType”: “dateTime”,

          “formatString”: “dddd\, mmmm d\, yyyy”,

          “summarizeBy”: “none”

        }

      ]

    },

    {

      “name”: “sales”,

      “columns”: [

        {

          “name”: “Date”,

          “dataType”: “dateTime”,

          “formatString”: “dddd\, mmmm d\, yyyy”,

          “summarizeBy”: “none”

        },

        {

          “name”: “Sales”,

          “dataType”: “int64″,

          “formatString”: “0”,

          “summarizeBy”: “sum”

        }

      ],

      “measures”: [

        {

          “name”: “percent to forecast”,

          “expression”: “SUM(sales[Sales])/SUM(forecast[forecast])”,

          “formatString”: “0.00 %;-0.00 %;0.00 %”

        }

      ]

    },

    {

      “name”: “forecast”,

      “columns”: [

        {

          “name”: “date”,

          “dataType”: “dateTime”,

          “formatString”: “m/d/yyyy”,

          “summarizeBy”: “none”

        },

        {

          “name”: “forecast”,

          “dataType”: “int64″,

          “formatString”: “0”,

          “summarizeBy”: “sum”

        }

      ]

    }

  ],

  “relationships”: [

    {

      “name”: “2ea345ce-b147-436e-8ac2-9d3c4d82af8d”,

      “fromTable”: “sales”,

      “fromColumn”: “Date”,

      “toTable”: “Date”,

      “toColumn”: “Date”,

      “crossFilteringBehavior”: “bothDirections”

    },

    {

      “name”: “5d95f419-e589-4345-9581-6e70670b1bba”,

      “fromTable”: “forecast”,

      “fromColumn”: “date”,

      “toTable”: “Date”,

      “toColumn”: “Date”,

      “crossFilteringBehavior”: “bothDirections”

    }

  ]

}

Let’s block ads! (Why?)

Microsoft Power BI Blog | Microsoft Power BI