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

Interkoubess's avatar
Interkoubess
Solution Sage
8 years ago

Hi pfederica,

 

Yes you must create a calendar table with unique values ( there are lot of examples on the forum).

 

Because PB uses these uniques values to process time intelligence functions.

 

Let us know if you are experiencing some difficulties we can help.

 

Ninter.