Hi All,
I am working on my powerpivot and trying to create a DAX formula to capture items with a duration that are equal to and greater than 30 seconds (>=). Here's the sample table that I have
Stel Table.JPG
Initially, I am using this formula =CALCULATE(COUNTROWS(STel),STel[Duration]>="0,0,30"), but it is counting everything. By the way the duration format is "hh:mm:ss AM/PM"
Thanks for your help!
Bookmarks