Alert Column

[reportuser]

Hello Community,

This is the table
Duration in seconds column

How can I add one more column which would say

Psuedocode/logic

IF ([DurationInSecs]>600) THEN 'Warning Extended absense of [DurationInSecs] seconds' Else 'Below 600 seconds'

[Pragati11 · Accepted solution]

Hi @reportuser ,

You can create a calculated column using following DAX expression:

FlagColumn = IF ('Table1'[DurationInSecs] > 600, 

                              CONCATENATE("Warning Extended absense of ", CONCATENATE('Table1'[DurationInSecs], " seconds")),

                              "Below 600 seconds")

Replace 'Table1' in above dax with your table-name.

Thanks,

Pragati

[amitchandak]

@reportuser , try as a new column

IF ([DurationInSecs]>600, "Warning Extended absense of [DurationInSecs] seconds" , "Below 600 seconds")