How to FILTER by a timestamp

[Anonymous]

I have a calculated column that looks like this:

Time to publish = DATEDIFF(related(Header[Quote Creation Timestamp]),QuoteActivity[Publish Live Timestamp], MINUTE)

I basically want to do this calculation but JUST for timestamps after 6:59am. I want to exlude rows in this calculation who's time stamp is before 6:59am. 

Any help would be appreciated, thanks!

[v-juanli-msft]

Hi @Anonymous 

As tested, tarunsingla's formula is correct when the QuoteActivity[Publish Live Timestamp] is of time type.

If QuoteActivity[Publish Live Timestamp] is in date/time format, go to Edit Queries->Add column->Time->only time, then use the time field in the "IF" function as tarunsingla's example.

Best Regards

Maggie 

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[tarunsingla · Accepted solution]

Use an IF clause in your formula. Something like this:

Time to publish = IF(QuoteActivity[Publish Live Timestamp] > TIME(6,59,0) , DATEDIFF(related(Header[Quote Creation Timestamp]),QuoteActivity[Publish Live Timestamp], MINUTE), BLANK())

References:

https://docs.microsoft.com/en-us/dax/if-function-dax

https://docs.microsoft.com/en-us/dax/time-function-dax

Regards,

Tarun

Did I answer your question? Mark my post as a solution!