Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello Community,
This is the table
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'
Solved! Go to 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
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
@reportuser , try as a new column
IF ([DurationInSecs]>600, "Warning Extended absense of [DurationInSecs] seconds" , "Below 600 seconds")
User | Count |
---|---|
86 | |
82 | |
68 | |
64 | |
55 |
User | Count |
---|---|
120 | |
99 | |
91 | |
83 | |
65 |