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, I'm trying to calculate the difference beetwen the sum of two columns from two tables based on a date in a new table
The variable suma_hoy is working perfectly, but the variable sum_pasada is gives me the follow error:
"DAX comparison operations do not support comparing values of type Date with values of type Text. Consider using the VALUE or FORMAT function to convert one of the values."
I've checked the type of my column Seguimiento_fecha, and it seems to be correct:
Why am I getting that error? How should calculate that difference properly?
Solved! Go to Solution.
Hi Pumpikin,
In line 2 for the variable days_before, NOW() returns a date and time. Try using TODAY() that returns date only.
The function FORMAT turns the value into a Text, so it cant be compared with a data.
try this for your days_before:
VAR days_before = TODAY() - 7
Hi Tutu, thanks for your help, but still not working.
The filter is no working properly, I think is because now() is retrieving as dd/mm/yyyy HH:mm:ss and the column in my table is dd/mm/yyyy so they are not matching.
Try replace now() with today()
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 |
---|---|
47 | |
26 | |
19 | |
14 | |
10 |
User | Count |
---|---|
58 | |
50 | |
44 | |
19 | |
19 |