Forum Discussion
pfederica
8 years agoFrequent Visitor
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...
- 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
pfederica
8 years agoFrequent Visitor
Hi v-piga-msft,
when i use the CALENDAR function the result is this:
The error message says that a date column has been specified with date duplicate.
And my data type is like that:
How can I do?
Thanks a lot
v-piga-msft
8 years agoResident Rockstar
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
- Mansi26_AT1 year agoNew Member
Still getting error