Calendar condition - How to show Calendar[Date]>TODAY (including) full current month

[Anonymous]

Dear,

I have an issue regarding a conditional column in the calendar. In fact, I would like to show the 'Calendar'[Date]>TODAY() BUT including the full current month.

When I do the previous formula, it did not include the month of November. 

Do you have a Formula to show the 'Calendar'[Date]>TODAY() including the full current month (even if we are the 25/11) ? 

Thanks you.

[v-shex-msft · Accepted solution]

HI @Anonymous ,

You can use YEAR, MONTH function to extract 'year', 'month' from TODAY function, then you can use DATE function combine them and get the last day of the previous month and compare with your column date values.

formula =
IF (
    'Calendar'[Date]
        > DATE ( YEAR ( TODAY () ), MONTH ( TODAY () ), 1 ) - 1,
    1
)

Regards,

Xiaoxin Sheng

[Anonymous]

Hi,

if I had to my Dim_Date table a new column = IF(Dim_Date[Date]>TODAY(),1,0) the formula works fine and Tomorrow has 1.

How do you build your Calendar Table? 

Regards

Lorenzo

[kentyler]

Lorenzo,

I use the Calendar table from this link https://www.youtube.com/watch?v=zXZAZrUwUe8

[kentyler]

You should be able to use this DAX function :

Returns the first date of the month in the current context for the specified column of dates.

Syntax

DAXCopy

STARTOFMONTH(<dates>)  

 so your formula would become 

'Calendar'[Date]>STARTOFMONTH(TODAY() )
I'm a personal Power BI Trainer 

[amitchandak]

Try Datesmtd

This Month = CALCULATE(sum(Sales[Sales Amount]),DATESMTD('Date'[date]))  

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks.

My Recent Blog - https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601