sales in last 3 days filtering on store and product level

[Avinash19]

Hi,

Need an help with below query

I want to calculate last 3 days sales of a product in a particular store, so if there is a sale in last 3 days then it will display result as 1 but if there is no sale in last 3 days then result should be 0.

STORE

---------

date	product_id	store_id	cnt_txns
08/04/24	4051	491	1
09/04/24	40880	491	1
10/04/24	40880	491	1
11/04/24	40880	491	1

OUTPUT

---------

date	product_id	store_id	last 3  days txns
12/04/24	4051	491	0 (no sale on 9th,10,11)
12/04/24	40880	491	1 (there was a sale in past 3 days)

can someone please help me with the dax here?

[ryan_mayu · Accepted solution]

@Avinash19 

pls try this

Column =

VAR _count=CALCULATE(COUNTROWS('Table'),FILTER('Table','Table'[  product_id]='Table (2)'[  product_id]&&'Table'[  store_id]='Table (2)'[    store_id]&&'Table'[date   ]<'Table (2)'[date   ]&&'Table'[date   ]>='Table (2)'[date   ]-3))

return if(_count>=1,1,0)

pls see the attachment below