Comparing Dates in Measure

[Jo5hua22]

Hi Users,

I am stuck with comparing dates in a Measure variable. Can you please help me out?

Scenario:

I need to compare the Month(Today()) with the month in column value. If both Months are same, then I need to perform a calculation. 

Example:

VAR X1 = If (Month(Today())==Month(Table[Date]),"1","0")

Can you please help me?

[v-yangliu-msft · Accepted solution]

Hi  @Jo5hua22 ,

Here are the steps you can follow：

1. Create measure.

Measure =
IF(
    MONTH(MAX('Table'[Date]))=MONTH(TODAY()),1,0)

2. Result:

The month of each date data is compared to today's month.

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[amitchandak]

@Jo5hua22 , You can have it like this

If (eomonth(Today(),0)=eoMonth(Table[Date],0),"1","0")

This is more for column then measure 

for measure you might need

If (eomonth(Today(),0)=eoMonth(max(Table[Date]),0),"1","0")

[Jo5hua22]

Thanks sir

The statement "eoMonth(max(Table[Date]),0)," is showing different value that is 31/12/2022.

eomonth(Today(),0) shows the value of 31/01/2022. I would like to compare each month's value with the column value in Table[Date]