Slicer Date Range

Hi Ani,

Could You please write dax for following Scenrio.

if i select multiple dates as above slicer(i.e 4/4/2019 to 4/30/2019) i need latest sales quantity as from 4/3/2019 to 4/30/2019 and if i select single date(i.e 4/4/2019 to 4/4/2019) i need sales quantity from 4/3/2019 to 4/4/2019.

if i select multiple dates as above slicer(i.e 4/4/2019 to 4/30/2019), i need latest count of items as latest date(i.e 4/30/2019) item count and previous count of items as previous date(i.e 4/3/2019) item count and if i select single date(i.e 4/4/2019 to 4/4/2019) i need bothe latest and previous itemcount as 4/4/2019.

Thank You

---

Ani1991 wrote:

Hi Anonymous ,

 

You can try the following,

PreviousDaySales = CALCULATE(SUM(Table[SALES]),Filter(Table,Date = DATEADD(Table[Date],-1,DAY))

---

---

Ani1991 wrote:

Hi Anonymous ,

 

You can try the following,

PreviousDaySales = CALCULATE(SUM(Table[SALES]),Filter(Table,Date = DATEADD(Table[Date],-1,DAY))

---