Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

Mark as date

I would like to mark as date a column to create a map too show the variation of the defect number. 

I can't do it : when I select the column I want as date an error appears: 

"The date column must have unique values. The date column can't have differences between dates". I don't get this message. 

What can I do? 

Thanks for your help

1 ACCEPTED SOLUTION
PaulDBrown
Community Champion
Community Champion

You need to create a date table with unique continuous vales of dates covering the range of dates in the model. You can do this in Power Query or by creating a new table using the DAX functions CALENDAR or CALENDARAUTO. 
Do you have sample data or PBIX file?





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






View solution in original post

2 REPLIES 2
V-lianl-msft
Community Support
Community Support

You could create a calculated table with CALENDAR function or CALENDARAUTO function.
Calendar table =  CALENDAR(MIN('table'[date]), MAX('table'[date]))

Then you could create the relationships between the Calendar table and your original table.

PaulDBrown
Community Champion
Community Champion

You need to create a date table with unique continuous vales of dates covering the range of dates in the model. You can do this in Power Query or by creating a new table using the DAX functions CALENDAR or CALENDARAUTO. 
Do you have sample data or PBIX file?





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






Helpful resources

Announcements
Sept PBI Carousel

Power BI Monthly Update - September 2024

Check out the September 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors