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.
DATEDIFF doesn't show the expected difference. I am trying to calculate "Months from first purchase".
Both columns are the same date format. The difference I get is not correct.
This is a calcualted column:
Thanks,
Erez
Solved! Go to Solution.
It looks like you pulled that column into a visual and the field is set to SUM. My guess is the second line represents 3 records in your data set (4 months diff * 3 = 12) and the third line is covering 2 records. Try changing the field to show the AVERAGE.
Could it be your date format? I tried with MM/DD/YYYY format and DATEDIFF works perfectly fine.
Another alternate formula could be:
Hi @erezbenmoshe ,
Works here.
Proud to be a Super User!
It looks like you pulled that column into a visual and the field is set to SUM. My guess is the second line represents 3 records in your data set (4 months diff * 3 = 12) and the third line is covering 2 records. Try changing the field to show the AVERAGE.
You are right!! I am embarrassed that I did not figure it out myself 🙂
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 |
---|---|
111 | |
95 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |