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.

Ritaf1983's avatar
Ritaf1983
Icon for Super User rankSuper User
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 🙂