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 Raveeshlokanath 

First, I see that your data type is date/time rather than Date.

So, I would first try changing it to Date.

Unfortunately, I don't have any experience with direct query.

So, if the changes I suggested don't work, I recommend simply writing your question as a well-organized post with all the details.

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