Forum Discussion
PBSuper
9 years agoFrequent Visitor
MTD Previous
I am using SAMEPERIODLASTYEAR for my MTD Last Year calculation, however it returns Sales for the entire month of the previous year. So if I am reporting MTD sales for 17-08-2017, the MTD Last Year I ...
v-jiascu-msft
9 years agoMicrosoft Employee
Hi PBSuper,
Could you please mark the proper answer as solution or share the solution if it's convenient for you? That will be a big help to the others.
Best Regards!
Dale
PBSuper
9 years agoFrequent Visitor
After trying various ideas to no avail, I had to resort to splitting my last year sales from this year sales in my tabular model. This seems to be working fine.
Thank you all for your help again.