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

DAX Calendar Function - Bizarre duplicate date

Hi,

I have a pretty simple Date table built through DAX, that is each date since 1/1/2010.

 

Date = CALENDAR(DATE(2010,1,1),TODAY())

 

 

It has worked fine for many months, but for some bizarre reason, now there are two 30/9/2017 values, and no 1/10/2017 values. And it seems the hierarchy still works, but not the date itself.

 

image.png

 

 Because I want to show graphs in years + months (i.e. monthly trends over 2 years), I have a formula that is MM-YY:

 

MM-YY = DATE(year('Date'[Date]),month('Date'[Date]),1)

However, because of this odd error in the date, I get two September 2017s on the axis.

 

MM-YY - Two September 2017sMM-YY - Two September 2017s

 Any ideas? From memory this worked fine previously, but in the past couple months I've noticed the duplicate Septembers. It doesn't seem to do this with any other date in the table.

 

 

1 REPLY 1
Highlighted
Resident Rockstar
Resident Rockstar

Re: DAX Calendar Function - Bizarre duplicate date

Hi @kyle,

 

I have made a test with the dax you provided, but I cannot reproduce your issue in my environment.

 

What version of Power BI do you use, please update it to the latest version.

 

I suggest you could create a new calendar table to test if it still has this issue.

 

 

Besides, what data source have you connected and how do you coonect it?

 

If it is convenient, could you share a dummy pbix file which can reproduce the scenario, so that I can test it in my environment? You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading.)

 

Best Regards,

Cherry

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Upcoming Events

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors
Top Kudoed Authors