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)?
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.
See below screenshot with this filtering, hopefully that's as you wanted!
So just to be sure.
Year, Month and FYear are all in your DateTable.
SumLYLineValue:=Calculate(SumLineValue;Sameperiodlastyear(DateTable[Date]))
The Date columns are related and your DateTable is contigous.
Your raw data isn't limited. For example data for Fiscal Year 2016/2017 are filtered or similar?
Did you select different periods?
Yes all that is correct, I'll try starting fresh with just the data as it's getting a bit messy with the amount of relationships floating arond now. Hopefully the clean slate helps!
Can you remove months so just to compare the years?
Hi,
I've ended up starting again and doing some of the links from scratch, this has resulted in me actually ending up with the matrix successfully showing the last year value as intended! Unfortunately it now seems that the target part isn't linking into the matrix as intended. I won't trouble with more questions on it as I feel I am making progress but thanks so much for your help getting through the original issue!