Forum Discussion

ax80's avatar
ax80
New Member
5 years ago
Solved

USERELATIONSHIP WITH PREVIOUS YEAR DATE

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

Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    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]))

2 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    5 years ago

    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]))

  • Kidata's avatar
    Kidata
    Regular Visitor
    3 years ago

    Try this:

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

    SAMEPERIODLASTYEAR('Date'[Date]))