Forum Discussion

JCBI1023's avatar
JCBI1023
Icon for Helper III rankHelper III
8 years ago

Year Over Year by Month

Hello Masters!   This should be simple. I have two measures  [Forklift New Sales 2016] which sums the 2016 FY GP and [Forklift New Sales 2017] which sums the 2017 FY GP.   I have a Date Table: D...
Need Help
JCBI1023's avatar
JCBI1023
Icon for Helper III rankHelper III
8 years ago

Hello v-sihou-msft,

 

Your column name in the picture says "month name" but your custom sort column says "month number". Do I have to create a customer month number column? How would that work? I created a custom month name column like you did:

 

Month Name = FORMAT ('Dates'[Date],"MMM")

 

 

v-sihou-msft's avatar
v-sihou-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

JCBI1023

 

Yes, you should have a Month Number column. You can just use MONTH() function on a Date column to get the month number. 

 

Regards,

  • JCBI1023's avatar
    JCBI1023
    Icon for Helper III rankHelper III
    8 years ago

    I just cannot figure out how to get the month number column. 

     

    • JCBI1023's avatar
      JCBI1023
      Icon for Helper III rankHelper III
      8 years ago

      v-sihou-msft

       

      Would I still be using Date > Month as my Axis? I am still getting January as the first month.