How to get month Number In DAX

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"
)

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