Forum Discussion
Total Sales Last Year , Need Help!!
Im on a project to get rid of Tableau. I am having some issues with reporting on a value and the value in the same period last year. Im aware of the SAMEPERIODLASTYEAR function, my issue is that wh...
SAMEPERIODLASTYEAR did not work, PARALLELPERIOD worked perfectly when set to MONTH - 12
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