Forum Discussion
Dax SamePeriodLast year without dates
Hi all, I'm trying to get the sum of the sales in a table using the function sameperiodlastyear but, the question here is, is it possible use the sameperiodlastyear function with out dates? I ha...
sameperiodlastyear is a date function therefore it needs a date.
either add a date to your table which should be fairly easy to create?
vanessafvg thanks vanessa. That's the point, there is no Month 13 or 14 and is it possible that in my dataset appear because is not a date , is a period of the year.
Refer to my blog on
Also, refer to how rank can help you get a prior period this for the week but can be true for any custom period.
https://www.dropbox.com/s/d9898a48e76wmvl/sales_analytics_weekWise.pbix?dl=0
Anonymous ,Does the above reply helps. if you need more help make me @
Appreciate your Kudos.
