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 Retail_Transactions[Date] contains duplicate dates) with

Calendar =
CALENDAR(
    MIN(
        Retail_Transactions[Date]
    ),
    MAX(
        Retail_Transactions[Date]
    )
)

I joined these two tables in the model, but now when I'm creating line charts using this Calendar[Date] field, it doesn't show any result. If I use the field from Retail_Transactions[Date], it shows wrong results. When I turn off the relationship, and use Retail_Transactions[Date] field, it shows the correct result.

Can you tell me why I'm not able to use Calendar[Date] ?

Attaching screenshot for better clarity.
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.

8 Replies

  • Ritaf1983's avatar
    Ritaf1983
    Super 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.

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