Yesterday based on filter vs Any day of sales based on selection

[Anonymous]

Hi guys,

I need to calculated yesterday's data based on date slicer vs any day in the past based on user's selection

Yesterday will be always given from the date slicer, for example if the user put 11/11/2020 (the value will be from 10/11/2020)

I have worked out the yesterday's calculation which is:

Sales Yesterday =

CALCULATE( [Sales], FILTER(ALL('Date'), 'Date'[Date] = MAX('Date'[Date])-1 ) )

Then I need somehow to calculate the sales from yesterday vs any specifc day that the user select.

Do I need to create another date table? the user needs to have the ability to select a secondary date the sales from that date vs yesterday.

the trick is that yesterday's measure should be based on the date filter selection, like

max date -1

Any thoughts?

Thanks all

[Anonymous · Accepted solution]

@Anonymous 
You can use selectedvalue() and -1, to get the day before the selected date. 

Measure = CALCULATE(SUM('Table'[Sales]),FILTER(ALL('Table'),[Date]=SELECTEDVALUE('Table'[Date])-1))

Example:

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

[S_JB]

You could alter your measure for yesterday's sales so that a slicer isn't needed, then create a new measure which pulls back sales from the selected date in a slicer.

For yesterday's sales you could use this logic:
Sales Yesterday = CALCULATE(SUM([Sales]),Date=TODAY()-1)

You could then use logic similar to the below to pull back the date selected in your slicer:

Date Selected Sales = 
CALCULATE(SUM([Sales]),FILTER(ALLSELECTED([Date].[Date]),Date.Date<=MAX(Date.Date)))

[Anonymous]

Hi,

the problem that i can see in this solution is that my yesterday's measure must be dinamic regarding to the date filter as well

If the user select 10/11 the it should be 09/11 and so on.