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.