Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Measure affected by slicer

Hi,  I want to compare previos data to current data on a line graph. However, I also need to add a "year" slicer for the other objects. But with the presence of slicer, i need to select two consecut...
mwegener's avatar
mwegener
Icon for Most Valuable Professional rankMost Valuable Professional
6 years ago

Hi,

i think you can do this, with this DAX calculation

 

PREV Year =
CALCULATE (
    SUM ( 'Table'[Value] ),
    DATEADD ( 'Table'[Date].[Date], -1, YEAR )
)

 

If I answered your question, please mark my post as solution, this will also help others.

Please give Kudos for support.