IF date values in last week return 1

[HenryJS]

Hi all,

Please could you advise the DAX for below query

IF

• EITHER: PlacementDate is in the last 7 days
• OR ExtensionEndDate is in the last 7 days

THEN 1

ELSE 0

Thanks,

Henry

[Anonymous · Accepted solution]

Should work like this:

Column =

IF(

Table[Placementdate] >=TODAY() - 7 ||

Table[ExtensionEndDate ] >= TODAY - 7

1,

0

)

[Anonymous · Accepted solution]

Should work like this:

Column =

IF(

Table[Placementdate] >=TODAY() - 7 ||

Table[ExtensionEndDate ] >= TODAY - 7

1,

0

)

[HenryJS]

That only returns values that are both those statements

How do I return values

IF

Table[Placementdate] >=TODAY() - 7 

OR

Table[ExtensionEndDate ] >= TODAY - 7

[Anonymous]

The double pipe is equivalent to the OR operator. It should return 1 if either one of the mentioned conditions is true. Are you sure it's interpreting it as an AND condition? It would be very weird

[HenryJS]

Hi @Anonymous 

I can't work out why it's returning 1 for the below?

None of the dates are -7 from today?

[Anonymous]

I'm sorry I didn't understand that you also had future Dates in the target columns. You need to modify the code in this way:

Column =

IF(

(Table[column1] >= TODAY() - 7 && Table[column1] <= TODAY()) ||

(Table[column2] >= TODAY() -7 && Table[column2] <= TODAY()),

1,

0

)

In this way it also checks that the "upper" limit of the two dates is today.

[HenryJS]

Thanks @Anonymous 

That's worked.

Last point - how can I ammend so it returns the last 7 days NOT including today?

Cheers,

Henry

[Anonymous · Accepted solution]

Simply remove the equal operator from the second part of the two conditions, the ones that check that date is <=today. Just put inferior to today.