Forum Discussion
Comparing Last Year Sales Values
Hello,
please provide us the formula how you calculated SumLYLineValue.
Did you use Sameperiodlastyear or DateAdd(DateTable;-1;Year)?
Hello,
Is FYear a calculated column?
Please try to create FYear in your DateTable instead of your SageData.
I've created FYear in the date table now using FYear = IF(Month('Date'[Date])-3<1,CONCATENATE(YEAR('Date'[Date])-1,CONCATENATE("/",RIGHT(YEAR('Date'[Date]),2))),CONCATENATE(Year('Date'[Date]),CONCATENATE("/",RIGHT(YEAR('Date'[Date]),2)+1))). However I'm not sure if it helps as using this column for the slicer produces the same incorrect results.
Do you refer to the new FYear in your slicer?
Yes I used the new column but it didn't seem to make a difference. I was thinking of a different option where I could use something similar to the calculate function to say calculate line value where FY-Month=FYMonth-1. With FY-Month simply being FY and month concatenated and then FYMonth-1 being the equivalent value 1 year before i.e. FY-Month=2015/161 then FYMonth-1=2014/151
I've created the FYMonth-1 column without problems but can't seem to apply it how I want to the calculate function.
Thanks again, I hope I'm explaining things well enough
Hello,
can you make a Screenshot how it looks if you have Year in your column but FYear as slicer selected 2017?
Best regards.