Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to 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
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]
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
97 | |
84 | |
67 | |
59 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |