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.

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.

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