Forum Discussion
Sorting Summarized table
Hey Guys, I've got a summarized table based on unique streetnames and then a couple of date columns (begin and end) Those date columns are based on another table using MINX and MAXX I want to s...
Please provide sample data that fully covers your issue.
Please show the expected outcome based on the sample data you provided.
lbendlin i'll try to provide sample data
table 1
| Street | Begin | End |
| Street A | 01-09-23 | 08-09-23 |
| Street A | 02-09-23 | 06-09-23 |
| Street B | 05-09-23 | 12-09-23 |
| Street B | 12-09-23 | 28-09-23 |
| Street C | 14-09-23 | 16-09-23 |
| Street C | 03-09-23 | 04-09-23 |
| Street D | 04-09-23 | 05-09-23 |
| Street D | 11-09-23 | 18-09-23 |
| Street E |
Table 2 (using Summarize based on Table 1 and Street and MINX and MAXX for begin/end date)
| Street | Begin | End | SortOrder |
| Street A | 01-09-23 | 08-09-23 | 1 |
| Street B | 05-09-23 | 28-09-23 | 4 |
| Street C | 03-09-23 | 05-09-23 | 2 |
| Street D | 04-09-23 | 18-09-23 | 3 |
| Street E | 5 |
There is a relationship between the column Street in Table 1 and Street in Table 2 (many to one)
Then I wanted to sort the column Street (in Table 2) based on begin (chronologically) but that didn't work
Everything works and the SortOrder works fine but when I try to use the Sort By Column option in PowerBi desktop it returned the Circuler dependency error