Forum Discussion

unclejemima's avatar
unclejemima
Icon for Post Patron rankPost Patron
9 years ago
Solved

IsCurrentMonth DAX formula?

I've got a formula for IsCurrentWeek, IsLastWeek, IsLast7Days, IsToday...but I don't have a forumla for IsCurrentMonth.

 

Can anyone help out with a DAX formula for this?

Thanks!

Need Help
  • unclejemima's avatar
    unclejemima
    9 years ago

    Found it!

     

    IsCurrentMonth = 
    IF (
        YEAR ( Table1[Create Date] ) = YEAR ( TODAY () )
            && MONTH ( Table1[Create Date] ) = MONTH ( TODAY () ),
        "Yes",
        "No"
    )

1 Reply

  • unclejemima's avatar
    unclejemima
    Icon for Post Patron rankPost Patron
    9 years ago

    Found it!

     

    IsCurrentMonth = 
    IF (
        YEAR ( Table1[Create Date] ) = YEAR ( TODAY () )
            && MONTH ( Table1[Create Date] ) = MONTH ( TODAY () ),
        "Yes",
        "No"
    )