Forum Discussion

florentbignier's avatar
florentbignier
Helper I
5 years ago
Solved

Interaction between 2 date slicers

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

Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    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 ))

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    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 ))