cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Regular Visitor

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

Hi,

 

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

 

 
 

Capture.PNG

 

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

 

error.PNG

 

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

 

date.PNG

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User IV
Super User IV

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

@djwitkowski 

Is the POS column a date as well?

LastDate.jpg

View solution in original post

3 REPLIES 3
Highlighted
Super User IV
Super User IV

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

@djwitkowski 

Is the POS column a date as well?

LastDate.jpg

View solution in original post

Highlighted
Regular Visitor

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

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!

Highlighted
Super User IV
Super User IV

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

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

Glad I could help!

Helpful resources

Announcements
Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Power Platform 2020 release wave 2 plan

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors