Forum Discussion
Sorting error - can't be more than one value
It's a little tricky because we can't see the YearFinMonthDay values you have.
However, the error is caused because there are more than 1 value for YearFinMonthDay for one WorkWeek e.g. 29/ Mar/21 - 04/Apr/21 will have 5 values of YearFinMonthDay. Powerbi doesn't know which to use.
You need to find something to order by that has the same granularity as WorkWeek, something like Year and weeknum combined OR Year and 1st Day of workweek combined.
That's my theory.
Community ChampionIt's a little tricky because we can't see the YearFinMonthDay values you have.
However, the error is caused because there are more than 1 value for YearFinMonthDay for one WorkWeek e.g. 29/ Mar/21 - 04/Apr/21 will have 5 values of YearFinMonthDay. Powerbi doesn't know which to use.
You need to find something to order by that has the same granularity as WorkWeek, something like Year and weeknum combined OR Year and 1st Day of workweek combined.
That's my theory.
thanks alot. that really clears things up.
i've manage to do it !
cheers,