Forum Discussion

florentbignier's avatar
florentbignier
Icon for Helper I rankHelper 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 ...
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 ))

amitchandak's avatar
amitchandak
Icon for Super User rankSuper 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 ))