Get the current month

[ganeshnr073]

I have a column with months in it. Need it to be filtered with current month so that I can perform calculation after it. Kindly help to get the current month and dynamically it will change to next month and so on. 

[davehus]

Hi @ganeshnr073 , You're more than welcome. 🙂

[davehus]

Hi @ganeshnr073 ,

Add a calculated column to your table as below.

Hope this helps

Did I help you today? Please accept my solution and hit the Kudos button.

MonthNum = Var vMonthNum = MONTH(DATEVALUE('Table'[Month]&"/01/01"))
Var vCurMonth = MONTH(TODAY())
Var IsCurMonth = IF(vMonthNum = vCurMonth,"Y","N")
Return IsCurMonth

[davehus · Accepted solution]

Hi @ganeshnr073 ,

Add a calculated column to your table as below.

Hope this helps

Did I help you today? Please accept my solution and hit the Kudos button.

MonthNum = Var vMonthNum = MONTH(DATEVALUE('Table'[Month]&"/01/01"))
Var vCurMonth = MONTH(TODAY())
Var IsCurMonth = IF(vMonthNum = vCurMonth,"Y","N")
Return IsCurMonth

[ganeshnr073]

Thank you for the help ! it worked 

Cheers !!