Forum Discussion
Finding a value where another column in the same table has the same column value but -1
Hola kind people! A bit of an exhaustive title, but this captures what I am trying to do from an analytical perspective, I believe. Functionally put, I want to find a value (e.g. sales) of 'l...
A small update:
Value_YA = CALCULATE(SUM(Table[Value]), FILTER(ALLSELECTED(Table),Table[Year-Month-Day]=MAX(Table[Year-Month-Day])-364))
This works! Except... Except that when you filter the table on e.g. year 2022, the calculation finds it impossible to retrieve the 2021 numbers it needs to give me the numbers from a year ago. Can that be circumvented?