Date subtraction in set analysis

[inescastelhano]

Hello everyone,

I have a problem in a set analysis expression: I want to know if a certain date is less than 2 days from now.

This is supposed to be the expression: [myDate]-ReloadTime()<2

This is my set analysis expression, but it does not work.

=sum({< [myDate]-Date(ReloadTime())={'<$(=2)'}>}[Count Sales])

Any help would be appreciated.

Cheers,

Ines

[Clever_Anjos]

=sum({< [myDate]={'<$(=Date(ReloadTime()-2))'}>}[Count Sales])

[sunny_talwar · Accepted solution]

May be this:

=Sum({<myDate = {"=myDate - ReloadTime() <=2"}>}[Count Sales])

[inescastelhano]

Hi,

Thanks for your answer. However, it does not work, as you can see in the following print screen:

Thanks in advance.

[inescastelhano]

Now it works! Many thanks!