Forum Discussion
Total Sales Last Year , Need Help!!
SAMEPERIODLASTYEAR did not work, PARALLELPERIOD worked perfectly when set to MONTH - 12
This may cause more of a problem then a help but I have noticed that sometimes if you can get your data to show 0 instead of blank formulas have a way of behving differently.
New Sales = If(SUM(Sales)=0,"0",SUM(Sales))
or
New Sales = If(SUM(Sales)=BLANK(),"0",SUM(Sales))
depending on how the data is working
It would force data where there is none. Just an idea but I have not tested this.
Nah no good, the issue is that for the new time period there isnt data thats zero, there is just NO data.
E.G. the data looks like
01-Aug-2018 | 75
02-Aug-2018 | 150
03-Aug-2018 | 65
04-Aug-2018 | 48
END
But if i set the range to 2017 there is data for the whole month last year, but the powerbi table is only calculating it for the 01 to the 04 august in the above example
The saddest thing is, i can make EXACTLY what i need in a Stored Procedure in SQL, but then it would need to be run every time for every different month range.
SAMEPERIODLASTYEAR did not work, PARALLELPERIOD worked perfectly when set to MONTH - 12