Not Recognizing data type as Date, even though that's what's selected

[djwitkowski]

Hi,

I am trying to perform a rolling average calculation, and I have the following DAX:

when i try putting the measure into a table, i get this message:

You can clearly see though that the column I used is a DATE... Does anyone have any insights?

[jdbuchanan71 · Accepted solution]

@djwitkowski 

Is the POS column a date as well?

[djwitkowski]

I feel incredibly dumb. I was copying the DAX from someone else in my company who had done the calculation before and I didn't catch that I put the wrong column in. Thank you for the second set of eyes!

[jdbuchanan71]

I've totally never ever done anything like that at all.  😁

Glad I could help!