Forum Discussion

yush_amateur's avatar
yush_amateur
Regular Visitor
2 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
    2 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.

yush_amateur's avatar
yush_amateur
Regular Visitor
2 years ago

Hi Ritaf1983 ,

Thank you for the solution. I had checked that in the PQ, and it correctly showed Date/Time, but this time I changed it regardless to Date, and then it worked.   
Thank you.

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

Happy to help 🙂