Forum Discussion

pfederica's avatar
pfederica
Frequent Visitor
8 years ago
Solved

date column must contain unique values

Hi everyone,

i'm new on Power Bi.

i have sales data: i have a row for each sale at any time for different customers. So, my column timestamp is not univoque.

I'm tryng to mark a DateTable using my datetime column, but Power Bi tells me that that column must contain unique values.

How can i resolve it? 

 

Thanks very much!

  • v-piga-msft's avatar
    v-piga-msft
    8 years ago

    Hi  pfederica,

     

    For your scenario, you could use MIN and MAX function because you have duplicate date which FIRSTDATE is not supported..

     

     

    Best Regards,

    Cherry