search

samaguire / TabularEditorScripts

MIT License
19 stars 0 forks source link

Create zeros and blanks calculation group macro #13

Open samaguire opened 2 years ago

samaguire commented 2 years ago 
{
  "InstanceID": "144a62ac-4cbc-425c-9e48-777286690bb1",
  "calculationgrouptables": [
    {
  "name": "Zero & Blank Handling",
  "lineageTag": "942a9ac5-3f4a-4598-bd08-91d10735c089",
  "modifiedTime": "2022-04-25T10:08:46.976667",
  "structureModifiedTime": "2022-04-11T02:11:21.843333",
  "calculationGroup": {
    "modifiedTime": "2022-04-11T02:11:21.843333",
    "calculationItems": [
      {
        "name": "Blank to Zero",
        "expression": "\nVAR MeasureSelected = SELECTEDMEASURE( )\nRETURN\n    IF( ISBLANK( MeasureSelected ), 0, MeasureSelected )",
        "modifiedTime": "2022-04-20T11:15:54.086667"
      },
      {
        "name": "Zero to Blank",
        "expression": "\nVAR MeasureSelected = SELECTEDMEASURE( )\nRETURN\n    IF( MeasureSelected == 0, BLANK( ), MeasureSelected )",
        "modifiedTime": "2022-04-20T11:15:54.086667"
      },
      {
        "name": "Hide Blank",
        "expression": "\nVAR MeasureSelected = SELECTEDMEASURE( )\nRETURN\n    IF( ISBLANK( MeasureSelected ), \"\", MeasureSelected )",
        "modifiedTime": "2022-04-20T11:15:54.086667"
      },
      {
        "name": "Hide Zero",
        "expression": "\nVAR MeasureSelected = SELECTEDMEASURE( )\nRETURN\n    IF( MeasureSelected == 0, \"\", MeasureSelected )",
        "modifiedTime": "2022-04-20T11:15:54.086667"
      }
    ]
  },
  "columns": [
    {
      "type": "rowNumber",
      "name": "RowNumber-2662979B-1795-4F74-8F37-6A1BA8059B61",
      "dataType": "int64",
      "isHidden": true,
      "isUnique": true,
      "isKey": true,
      "isNullable": false,
      "modifiedTime": "2022-04-11T02:11:27.786667",
      "structureModifiedTime": "2022-04-11T02:11:21.843333",
      "refreshedTime": "1699-12-31T00:00:00",
      "attributeHierarchy": {
        "state": "ready",
        "modifiedTime": "2022-04-11T02:11:27.786667",
        "refreshedTime": "2022-04-11T02:11:27.786667"
      }
    },
    {
      "name": "Zero & Blank Handling",
      "dataType": "string",
      "sourceColumn": "Name",
      "sortByColumn": "Ordinal",
      "lineageTag": "61501815-bf57-4d96-b06a-cc1c1ac509e3",
      "summarizeBy": "none",
      "modifiedTime": "2022-04-25T09:48:35.47",
      "structureModifiedTime": "2022-04-11T02:11:21.843333",
      "refreshedTime": "1699-12-31T00:00:00",
      "attributeHierarchy": {
        "state": "ready",
        "modifiedTime": "2022-04-11T02:11:27.79",
        "refreshedTime": "2022-04-11T02:11:27.79"
      },
      "annotations": [
        {
          "name": "PBI_ChangedProperties",
          "value": "[\"IsHidden\"]",
          "modifiedTime": "2022-04-11T02:11:21.843333"
        },
        {
          "name": "SummarizationSetBy",
          "value": "Automatic",
          "modifiedTime": "2022-04-11T02:11:21.843333"
        },
        {
          "name": "BestPracticeAnalyzer_IgnoreRules",
          "value": "{\"RuleIDs\":[\"UNNECESSARY_COLUMNS\"]}",
          "modifiedTime": "2022-04-11T02:11:21.843333"
        }
      ]
    },
    {
      "name": "Ordinal",
      "dataType": "int64",
      "isHidden": true,
      "sourceColumn": "Ordinal",
      "encodingHint": "value",
      "lineageTag": "548186d6-0db2-45f2-a8ee-c187f7bd56c5",
      "summarizeBy": "none",
      "modifiedTime": "2022-04-11T02:11:27.786667",
      "structureModifiedTime": "2022-04-11T02:11:21.843333",
      "refreshedTime": "1699-12-31T00:00:00",
      "attributeHierarchy": {
        "state": "ready",
        "modifiedTime": "2022-04-11T02:11:27.786667",
        "refreshedTime": "2022-04-11T02:11:27.786667"
      },
      "annotations": [
        {
          "name": "PBI_ChangedProperties",
          "value": "[\"IsHidden\"]",
          "modifiedTime": "2022-04-11T02:11:21.843333"
        },
        {
          "name": "SummarizationSetBy",
          "value": "User",
          "modifiedTime": "2022-04-11T02:11:21.843333"
        }
      ]
    }
  ],
  "partitions": [
    {
      "name": "Partition",
      "mode": "import",
      "state": "ready",
      "modifiedTime": "2022-04-11T02:11:27.786667",
      "refreshedTime": "2022-04-11T02:11:27.786667",
      "source": {
        "type": "calculationGroup"
      }
    }
  ],
  "annotations": [
    {
      "name": "PBI_ChangedProperties",
      "value": "[\"IsHidden\"]",
      "modifiedTime": "2022-04-11T02:11:21.843333"
    }
  ]
}
  ]
}