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:
Go to 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"))
Proud to be a Super User!
View solution in original post
Check out new user group experience and if you are a leader please create your group!
Check out how to claim yours today!
Test your skills now with the Cloud Skills Challenge.