Forum Discussion

krishna_murthy's avatar
krishna_murthy
Icon for Helper II rankHelper II
1 year ago
Solved

How to get month Number In DAX

Hi Team,

 

Here is the question 

IF(Jan =01,
(Feb= 02,
(Mar=03.
.
..
..
Dec=12))))))

 

Please check how we can achieve on the DAX measaure 

  • Jihwan_Kim's avatar
    Jihwan_Kim
    1 year ago

    Hi,

    Please check the below picture and the attached pbix file.

     

     

     

    month number CC =
FORMAT (
    CONVERT (
        YEAR ( TODAY () ) & "-" & 'month'[month name] & "-"
            & DAY ( TODAY () ),
        DATETIME
    ),
    "mm"
)
  • v-menakakota's avatar
    v-menakakota
    1 year ago

    Hi krishna_murthy ,

    I hope the provided information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, please Accept it as a solution and give it a 'Kudos' so others can find it easily.

    Thank you

4 Replies

  • Jihwan_Kim's avatar
    Jihwan_Kim
    Icon for Super User rankSuper User
    1 year ago

    Hi,

    Please check the below picture and the attached pbix file.

     

     

     

    month number CC =
FORMAT (
    CONVERT (
        YEAR ( TODAY () ) & "-" & 'month'[month name] & "-"
            & DAY ( TODAY () ),
        DATETIME
    ),
    "mm"
)
  • Deku's avatar
    Deku
    Icon for Super User rankSuper User
    1 year ago

    If you have a date you can extract with

     

    month( table[date])

     

    Otherwise you will have to use 

     

    Switch(

    Selectedvalue( table[month name])

    ,"Jan", 1,

    ....

    )

  • v-menakakota's avatar
    v-menakakota
    Icon for Community Support rankCommunity Support
    1 year ago

    Hi krishna_murthy  ,

    I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If the response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.

    Thank you.

    • v-menakakota's avatar
      v-menakakota
      Icon for Community Support rankCommunity Support
      1 year ago

      Hi krishna_murthy ,

      I hope the provided information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, please Accept it as a solution and give it a 'Kudos' so others can find it easily.

      Thank you