Forum Discussion
Solved
Dax Bug or Code Error?
Hey Community, I have a weird one here where my data column is doing a Last week vs a Week 1 year ago and for some reason most of the math is right but some years think they are in the 2100s+ for some odd reason. Here is a screenshot anything obvious I missed?
Hi NL-Nicolas
your column DF_BusinessDay is text format. You need to fix that in power query and assign date data type to this column.
4 Replies
Hi NL-Nicolas
your column DF_BusinessDay is text format. You need to fix that in power query and assign date data type to this column.
So I tried fixing that inquery howevery it was already set to Date Time, I set it to just date and still same result... Gonna keep looking in the Query Editor I think you are on the right track
