Forum Discussion

IAmCare's avatar
IAmCare
Frequent Visitor
8 years ago

SamePeriodLastYear

Maybe I am missing something but shouldnt the current for 2017 be the Last for 2018?  Here is my code Current = CALCULATE(COUNTROWS('FactWholesale')) Last = CALCULATE([Current],SAMEPERIODLASTYEAR('...
Need Help
Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
8 years ago

Hi,

 

Share the link from where i can download your PBI file.

IAmCare's avatar
IAmCare
Frequent Visitor
8 years ago

I think I know what is going on.  Our fiscal month

September 2017 ran from

8/28/2016 -  10/01/2016

 fiscal month

September 2018 ran from

8/27/2017 -  9/30/2017. 

Our fiscal calendar  ends on the last Saturday of the month.  Is there a way to get the sameperiodlastyear to work with this type of monthly set up?