Dax countrows time greater than 48 hours

[Anonymous]

Hello, 

my goal is to show data that is older than 48 hours for the row "STBs[Settings completion time (First contact to SGIS)]".

i currently use the following dax calculation:

COUNTROWS(filter(STBs,STBs[Settings completion time (2h)] = BLANK() && STBs[Settings completion time (First contact to SGIS)] <> BLANK() && STBs[Settings completion time (First contact to SGIS)]>48

"STBs[Settings completion time (First contact to SGIS)]>48" does not seem to work. 

What would be the solution for this problem? 


Thank you very much. 


Kind Regards
Jannis

[v-rzhou-msft · Accepted solution]

Hi @Anonymous ,

Please make sure the data formart of STBs[Settings completion time (First contact to SGIS)] column.

If it is number format as below, your code should work. 

Measure = COUNTROWS(filter(STBs,STBs[Settings completion time (2h)] = BLANK() &&  STBs[Settings completion time (First contact to SGIS)]>48))

If it is time format, I suggest you to use HOUR() function to get hour number.

Measure = COUNTROWS(filter(STBs,STBs[Settings completion time (2h)] = BLANK() && HOUR( STBs[Settings completion time (First contact to SGIS)])>48))

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.