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

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,

....

)