Forum Discussion

tushargunjal's avatar
tushargunjal
New Member
9 years ago
Solved

How to arrange Months

Hi,

 

How to arrange month Jan-Feb. I have import excel sheet with month colom from Jan to Oct. Its not showing as per calender Months.

  • v-sihou-msft's avatar
    v-sihou-msft
    9 years ago

    tushargunjal

     

    Firstly, you need to add a calculated column with SWITCH() to conver the Month Name into Month Number: 

     

    Month_Number =
SWITCH (
    [MONTH],
    "August", 08,
    "December", 12,
    "July", 07,
    "November", 11,
    "October", 10,
    "September", 09,
    "April", 04,
    "February", 02,
    "January", 01,
    "March", 03,
    "May", 05,
    "June", 06
)

    Then combine year part and 1st to make it into a calendar date. 

     

    =Date(2017,[Month Number],1)

    Regards,

2 Replies

  • mikeborg82's avatar
    mikeborg82
    Icon for Advocate II rankAdvocate II
    9 years ago

    do you have a date dimension table in your model?  If not, google the M script for date dimension table powerbi.  Add that as a table and you can join your fact data to this table.  sort months by month number and you should be good.

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

    tushargunjal

     

    Firstly, you need to add a calculated column with SWITCH() to conver the Month Name into Month Number: 

     

    Month_Number =
SWITCH (
    [MONTH],
    "August", 08,
    "December", 12,
    "July", 07,
    "November", 11,
    "October", 10,
    "September", 09,
    "April", 04,
    "February", 02,
    "January", 01,
    "March", 03,
    "May", 05,
    "June", 06
)

    Then combine year part and 1st to make it into a calendar date. 

     

    =Date(2017,[Month Number],1)

    Regards,