Help: Sum by Slicer Dates, multiple date columns

[TS_PowerBI]

Hi all,

Stuggling to find a way to sum a data table based on the dates selected in a slicer. 

The data source has 3 date columns and 3 count coulmns. The result expected is "If between these dates, + Sold - Promo - Returned)

I have an excel forumula but can't figure out how to moce this into Power BI. 

DATA								Slicer
Product	Sold Date	Promo Date	Returned Date	Sold (+)	Promo (-)	Returned (-)		3/1/2021	3/31/2021
Grapes	3/3/2021	#	#	1	0	0
Grapes	3/1/2021	#	#	1	0	0		Result	4
Grapes	#	3/1/2021	#	0	1	0
Grapes	3/16/2021	#	#	1	0	0		=SUM( SUMIFS(E:E, B:B, ">="&I1, B:B, "<="&J1), -SUMIFS(F:F, C:C, ">="&I1, C:C, "<="&J1) -SUMIFS(G:G, D:D, ">="&I1, D:D, "<="&J1) )
Grapes	4/16/2021	#	#	1	0	0
Grapes	#	3/1/2021	#	0	1	0
Grapes	3/21/2021	#	#	1	0	0
Grapes	4/9/2021	#	#	1	0	0
Grapes	3/1/2021	#	#	1	0	0
Grapes	#	#	3/1/2021	0	0	1
Grapes	3/27/2021	#	#	1	0	0
Grapes	3/1/2021	#	#	1	0	0
Grapes	#	4/28/2021	#	0	1	0
Grapes	#	#	4/9/2021	0	0	1

[Ashish_Mathur · Accepted solution]

Hi,

You may download my PBI file from here.

Hope this helps.