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.

Raveeshlokanath's avatar
Raveeshlokanath
Frequent Visitor
2 years ago

 

Hi Ritaf1983  I can't share the pbi as it contains sensitive data..   please check the Pics above and if you suggest on nex steps will be helpful. Thanks in advance.

    • 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.