USERELATIONSHIP WITH PREVIOUS YEAR DATE

[ax80]

Hi all,

I'm using USERELATIONSHIP in a formula with dates and I need to substitute year of selected dates with previous year.

Dates are used a slicer on the page with yerarchy Year/Quarter/Month.

My current formula is this:

Amount =

CALCULATE(SUM(Table[Amount]);

USERELATIONSHIP('Date'[Date];Table[Document date]))

Any suggestion?

Thanls

[Kidata]

Try this:

CALCULATE(CALCULATE(SUM(Table[Amount]);
USERELATIONSHIP('Date'[Date];Table[Document date])),

SAMEPERIODLASTYEAR('Date'[Date]))

[amitchandak · Accepted solution]

@ax80 , Try like. Keep USERELATIONSHIP inside

CALCULATE( CALCULATE(SUM(Table[Amount]);
USERELATIONSHIP('Date'[Date];Table[Document date])) ,DATESYTD(dateadd('Date'[Date],-1,Year),"12/31"))

or

CALCULATE(CALCULATE(SUM(Table[Amount]);
USERELATIONSHIP('Date'[Date];Table[Document date])),previousyear('Date'[Date]))