Forum Discussion

bhmiller89's avatar
bhmiller89
Helper V
9 years ago
Solved

Measure for Current Month

I have a list of Opportunities and they all have create dates and close dates (projected and actual) I want to show only Opportunities created in the current month
Need Help
  • v-ljerr-msft's avatar
    v-ljerr-msft
    9 years ago

    Hi bhmiller89,

     

    In this scenario, you don't need to populate a date table. And I have created a simple sample about how to create the calculate column which indicates if the "create Date" is within current month for your reference.

     

    I assume you have a table called "Table1" like below.

    Then you should be able to use the formula below to create the calculate column, and use the created column as Slicer to show only Opportunities created in the current month.

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

    Regards

bhmiller89's avatar
bhmiller89
Helper V
9 years ago

v-ljerr-msft

 


Tried 

 

IsNextMonthClose = IF('dpmgr vwJMWebSalesOpportunitiesProduction'[CloseDate]= YEAR(TODAY()) && MONTH('dpmgr vwJMWebSalesOpportunitiesProduction'[CloseDate]= MONTH(TODAY()+1)), "Yes", "No")

 

but it's not working. is the "+1" not correct? 

EJNGE's avatar
EJNGE
Regular Visitor
3 years ago

Hello,

Just fell on this today, I know the post is old, as I was looking to do something similar and I tried this solution and I think it isn't working because you are adding 1 day to today rather than the month. I tried adding 29 days to today or having MONTH(TODAY())+1) and it seems to have worked.