iblockFrequent Visitor3 years agoPrior Year Sum in Column I am trying to create a column that will calculate the sum of "Weighting Base" but for the prior year. As you can see, it is returning only blank values right now. It should, for example, sho...Show More
iblockFrequent Visitor3 years agoI only have Contract Year (not the full date) and it is of type Whole Number, so the DATEADD function does not work here.
DOLEARY85Resident Rockstar to iblock3 years agoah okay, try this: CALCULATE(MAX('Table'[Sum Field]),FILTER('Table','Table'[Year Field]=EARLIER('Table'[Year Field])-1))
DOLEARY85Resident Rockstar to iblock3 years agoah okay, try this: CALCULATE(MAX('Table'[Sum Field]),FILTER('Table','Table'[Year Field]=EARLIER('Table'[Year Field])-1))
Related contentYOY change incorrect when prior year value is negativeNo prior year values since nothing defined?How do you calculate prior year values?Prior Month/Year Measures Not WorkingMonth/Year column
