Interaction between 2 date slicers

[florentbignier]

Hi,

I have a weekly report to do with graphs using datas of a selected week, and graphs using datas between the beginning of the year and this selected week.

I made a slicer with weeks, so it's ok for graphs using datas of a selected week. But how can I do (2nd slicer with interaction ? other solution ?) to have in the same page some graphs using datas between the beginning of the year and this selected week ?

Thanks,

Florent

[amitchandak · Accepted solution]

@florentbignier , Make sure you have Week year

Year Week = [Year]*100 +[Week]
YTD= CALCULATE(sum('order'[Qty]), FILTER(ALL('Date'),'Date'[Year]=max('Date'[Year]) && 'Date'[Week] <= Max('Date'[Week]) ))

YTD=

var _max = maxx(allselected(Date),'Date'[Week])

var _maxY = maxx(allselected(Date),'Date'[Year])

return

CALCULATE(sum('order'[Qty]), FILTER(ALL('Date'),'Date'[Year]=_maxY && 'Date'[Week] <= _max ))

[florentbignier]

Fantastic ! Thanks a lot @amitchandak 🙂