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
Super User
8 years ago

Hi,

 

You should not have a year in the Fiscal month column.  In the DimDate Table, extract the Month using the =FORMAT([Date],"mmmm").  Drag this Month column in the visual.

IAmCare's avatar
IAmCare
Frequent Visitor
8 years ago

I am getting this error mesage

when i do this

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super 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 do not know how to share the link to my PBIX without sharing all of my work, which I do not want to do.

    • 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?