Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Get data from filter for measure

    hi everyone, i need your help with this dynamic filter that i cant seem to find a solution for... how do i get the difference of the quantity between the 2 period that i selected from ...
stevedep's avatar
stevedep
Icon for Memorable Member rankMemorable Member
6 years ago

You are probably looking for a slightly different version:

Measure =
VAR MaxDate = MAX(ALLSELECTED ('Date'[Date]))
Var MinDate = MIN(ALLSELECTED ('Date'[Date]))
Return
CALCULATE( [your original measure], filter (all(date), date > mindate && date < maxdate))