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 month and so on. 

 

 

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

4 Replies

  • 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
  • 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