Forum Discussion
DATEDIFF messes with result
Hello, I am using the datediff function to get the days between Begin and End date. But is doenst count the days right. My daxfunction is: #Days = DATEDIFF(Data[Begindate];Data[Enddate];DAY)...
My fault alright. It had set an auto sum on the field.
I see that on a custom column a sum isnt shown with a total sign, so i didnt recgonised it at first.
evandrocunico
Resolver III
Resolver IIIHi Anonymous maybe check data type and format to begin and end date.
Regards.
- evandrocunico
I create a column DAYS, it works.
Can you provide the pbix?
My fault alright. It had set an auto sum on the field.
I see that on a custom column a sum isnt shown with a total sign, so i didnt recgonised it at first.