Search TipsEnhanced Calculated Fields - Existing Functions
Why is it Useful?
The visual calculated field feature allows dashboard designers to create a visual calculated field based on multiple fields across folders on a dashboard. This feature does not support creating a calculated field based on another calculated field. Now, with this enhancement, users can create more elaborate calculated fields that contain multiple calculation steps.
NOTE: This feature was released in Patch 19.
How Does it Work?
The following functions now support inputs that are not just values, but calculation expressions:
-
switch
-
date
-
date.addDays
-
date.dayDifference
-
trim
-
length
This enhancement makes it possible to create the following visual calculated fields:
Bill Rate = switch('Trades Codes'[Code] & ' Transactions'[Rate Code], "PSP1REG", 25, "PSP1OT", 30, 40) Important Date = date('Folder 1'[Year] + 1, 'Folder 2'[Month], 'Folder 3'[Day]) New Amount D = switch("Closed", 'Folder 1'[String Field], 1, 'Folder 2'[String Field], 2, 'Folder 3'[Number Field]/100) New Amount E = switch('Folder 1'[Number Field] * 'Folder 2'[Number Field], 'Folder 3'[Number Field], 1, 'Folder 4'[Number Field], 2, 3)
In addition, comparison operators (==, !=, <, <=, >, >= ) now support strings:
New Field 1 = switch(true, ‘folder’[text field] == “Some Value”,1,0)
To learn more about some of the latest features released in this patch, return to Patch 19 Highlights.