Count if the value repeats in a 24 hours interval

[FelipeSouzaWAM]

Hello everybody!
I have a question that probably has a very simple solution... as usual...

I need to count how many times a value repeats within 24 hours.

Normally, in Excel, a simple formula is enough.

COUNTIF(Table[PHONE],[@PHONE],Table[DATE],"<"&[@DATE]+1)

I tried everything in Load or SetAnalysis but without success.

I can't do it in base because it's a REST API.

Any idea?

[Rishabh_Chaudhary]

Hi @FelipeSouzaWAM  You can do something like 

Count({<Field_name = {"Timestamp(DateField) > = Timestamp(now() - 1)"}>}Field_Name)

Let me know if this works for you.