Forum Discussion

ganeshnr073's avatar
ganeshnr073
Helper I
3 years ago
Solved

Get the current month

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 mo...
Need Help
  • davehus's avatar
    davehus
    3 years ago

    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's avatar
davehus
Memorable Member
3 years ago

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's avatar
ganeshnr073
Helper I
3 years ago

Thank you for the help ! it worked 

Cheers !!