Forum Discussion

yush_amateur's avatar
yush_amateur
Regular Visitor
3 years ago
Solved

Duplicate Dates in Date column

Hi ! My original Retail_Transactions[Date] column contains duplicate dates, and hence I created another Calendar table (Because when I created columns with startofmonth, it threw an error that my Re...
Show and Tell
Tips and Tricks
  • Ritaf1983's avatar
    Ritaf1983
    3 years ago

    Hi yush_amateur 
    According to the lack of the calendar icon on your picture i see that "date" in the fact table is not date data type :

    Please change it with PQ 

    If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.

Raveeshlokanath's avatar
Raveeshlokanath
Frequent Visitor
2 years ago

I have the same issued, but data type is already set to Date, but it still shows duplaciates and Calendar Icon not appearing at all.

Ritaf1983's avatar
Ritaf1983
Icon for Super User rankSuper User
2 years ago

Hi Raveeshlokanath 

Please share link to the pbix and i 'll try to help.