Filter out everything above "00:15:00" minutes

[Anonymous]

So I got these timestamps "hh:mm:ss" and I would like to filter out everything above "00:15:00" minutes. I cant find any function to do that, do I need to make a measure and creata a new column?

[Thim · Accepted solution]

This should fix it.

Use this formula, and then add it as a filter to your matrix, or page, or all pages.

FilterAbove15Min = IF('Överlämning'[Inom 15 minuter]>1/24/60*15;"Remove";"Keep")

In Power BI the number 1 is one whole day, so we need to devide it with 24 hours, then 60 minutes, and then multiply it with the 15 minutes again. (1/24/60*15)

When you add this as a filter, then uncheck "Remove" and you should be all set. 🙂

[Anonymous]

Thank you, this worked perfectly!

[Anonymous]

@Anonymous can you please share sample data along with expected result after masking any sensitive data

Please try something like this

FILTER('Table',Minute("00:15:00)>15)

[Anonymous]

It doesnt work, i'm really new to this.

I tried this code:

FilterAbove15Min = FILTER('Överlämning';[Inom 15 minuter]("00:15:00)>15)

But I get Syntax error:

The following syntax error occurred during parsing: Invalid token, Line 1, Offset 40, "00:15:00)>15)))).

"Överlämning" is the whole table, and "Inom 15 minuter" is the column with the timestamps.

[Anonymous]

@Anonymous 

Please create a calculated column as below

column = IF(MINUTE('Överlämning'[Inom 15 minuter])>15,TRUE(),FALSE())