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
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.