Forum Discussion
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 same, then I need to perform a calculation.
Example:
VAR X1 = If (Month(Today())==Month(Table[Date]),"1","0")
Can you please help me?
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
3 Replies
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]
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
