Forum Discussion
DAX Issue.
Hi Experts, When I'm trying to create a measure I stuck up with below issue. Basicaly here I'm trying to display previous year values. I can use datediff but my column RPT Year is in Whole numb...
Anonymous
maybe you can try this
Test = CALCULATE(SUM(Query[Jan]),Query2[RPTyear]=SLECTEDVALUE(Query2[RPTyear])-1))