Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Day after Slicer date selection

Hello,   I feel like this particular issue is likely really simple but I can't find any good examples.    I have a really simple report with a date slicer and two visuals. I need one visual to di...
General Comment
Need Help
Tips and Tricks
  • jsaunders_zero9's avatar
    jsaunders_zero9
    4 years ago

    Hi jarnolky,

     

    You could also use DATEADD function

     

    Example 

    SalesTotal = SUM('SalesData'[Sales])

    SalesTotalNextDay = CALCULATE([SalesTotal],DATEADD(_Calendar[Date],1,DAY))

     

    Hope that helps.

     

    Thank you

     

     

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

Anonymous , if you need next day

 

example with date table and time intelligence

 

Next Day = CALCULATE(sum('Table'[Qty]), FILTER(ALL('Date'),'Date'[Date]=max('Date'[Date])+1))
Next Day = CALCULATE(sum('Table'[Qty]), nextday('Date'[Date]))