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
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