Dax Bug or Code Error?

[NL-Nicolas]

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?

[tamerj1 · Accepted solution]

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. 

[NL-Nicolas]

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

[AnkitKukreja]

Hi! @NL-Nicolas 

Is it possible to share the sample pbix to have a look at it?

[NL-Nicolas]

I cant in this regard due to the client but if there is anything you need to see I can share some Screenshots