Problem with Date-Function

[Tober1996]

Hello together, maybe an expert can help me?

Whats wrong in this code:

Result = IF((Table1[Site]="Memphis" || Table1[Site]="York") && YEAR(Table1[EndDate])<Date(2021,1,1), 0,Table1[Benefit1]+Table1[Benefit2])

This code works fine, but it is the wrong period:

Result = IF((Table1[Site]="Memphis" || Table1[Site]="York") && YEAR(Table1[EndDate])<YEAR(TODAY())-1, 0,Table1[Benefit1]+Table1[Benefit2])

Thanks for your support

Tober

[Tober1996]

Hello amichandak, thanks for your help. It's the same as my first version. I don't know why it works now. Most of the time, the fault is in front of the device.

Thanks again!

[amitchandak · Accepted solution]

@Tober1996 , This should be like

Result = IF((Table1[Site]="Memphis" || Table1[Site]="York") && (Table1[EndDate])<Date(2021,1,1), 0,Table1[Benefit1]+Table1[Benefit2])

If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.