Forum Discussion
Sorting Summarized table
Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot). Leave out anything not related to the issue.
https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
Based on anoter table ive created a new table using Summarize based on the streetname.
Then I've used the minx and maxx formula to search the other table on the first and last date (start date / end date)
Start Civiel = MINX(
Filter(
taken,Straten[adres straat]=Taken[adres straat]),
Taken[begin]
)
Eind Civiel = MAXX(
Filter(
taken,Straten[adres straat]=Taken[adres straat]),
Taken[eind]
)Some streets already have a plandate and some don't so the formula returns a BLANK()
But in my visual (custom Gantt Chart) i can't seem to sort the streets chronologically.
Therefore i was searching a way to do so and then I made a new column SortOrder using the RANKX formula.
Sortorder =
IF(
NOT(ISBLANK(Straten[Start Civiel])),
RANKX(
Filter(ALLSELECTED(Straten[Start Civiel]),NOT(ISBLANK(Straten[Start Civiel]))),
Straten[Start Civiel],
,ASC
)
)But when selecting the streetname in the visual and selecting (in the ribbon) sort by column the Sort Order it returns this circuler error between Straten[Street], Straten [SortOrder], Straten[Street]
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
What should happen if multiple streets have the same Begin date?