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('DimDate'[Date]))

 

578 for 2018 and 594 for 2017 is correct for the current but shouldnt  last for 2018 be the current for 2017 which is 594

 

 

 

 

mething but shouldnt the cu

Need Help

6 Replies

  • 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