Forum Discussion
Excel Power Pivot - issue Function SAMPLEPERIODLASTYEAR only works with contiguous date selections
Hi all, I have an error: Function SAMPLEPERIODLASTYEAR only works with contiguous date selections. I have a sales table with monthly sales data for 3 years. I have added a date table. And adde...
Hi verschug ,
danextian's workaround is great.
Could you please tell us if you have solved your problem?
If so, it's good to accept the reply as solution. More people will benefit from it because of this.
If not, please feel free to tell us.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly