Forum Discussion
Solved
Comparing Dates in Measure
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...
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
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")
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]