How to write set analysis beetwen two columns

[Mohamed23]

Hello, 
I have calendar (not linked to other sales table)

Date	Start	End
1.01.2020	1.01.2020	2.01.2020
2.01.2020	2.01.2020	4.01.2020

Date	Sales
2.01.2020	100
1.01.2020	50

How to write set analysis by using values in column start and end.

Sum({$<Date = {">=$(=Start)<=$(=End)"}>} Sales) 
I can not use 
Sum({$<Date = {">=01.01.2020<=01.01.2020"}>} Sales) 
or min or max based on selection. 
Is this any chance to calculate sum beetwen two columns?

[Benoit_C · Accepted solution]

Hi @Mohamed23,

Can you try the below ?
Sum({$<Date = {"=Date >= Start and Date <= End"}>} Sales)

This expression will sum the sales for dates that are greater than or equal to the start date and less than or equal to the end date.

Regards,

Benoit