I have table with data:
And I need to build a sequence of points (route) for each client and make a top10 of them. As a result I want to see:
Go to Solution.
@DarkAlex Please add an Index field in Power Query Editor and then add an supporting column in Data pane as below:
VAR _CurrVal = Test146MultiRowConcat[Points]
VAR _PrevVal = LOOKUPVALUE(Test146MultiRowConcat[Points],Test146MultiRowConcat[Clients],Test146MultiRowConcat[Clients],Test146MultiRowConcat[Date],Test146MultiRowConcat[Date],Test146MultiRowConcat[Index],Test146MultiRowConcat[Index]-1)
Now, your table will look like this...
Then, create a "New Table" as below (which will be the expected output)
Test146Out = SUMMARIZE(FILTER(Test146MultiRowConcat,Test146MultiRowConcat[ExcludeFlag]="N"),Test146MultiRowConcat[Clients],"Points",CONCATENATEX(Test146MultiRowConcat,Test146MultiRowConcat[Points],"-",Test146MultiRowConcat[Date],ASC,Test146MultiRowConcat[Time],ASC))
You can then create a measure to see the count for each Points as below
Test146Count = COUNT(Test146Out[Points])
Proud to be a Datanaut !
On this sample everything is ok, but I tried this on my data and have problem with repeating of points.
And the result is:
I don't realize, what I'm doing wrong. Can you help me with it?
Engage and empower students with Power BI!
Continue your learning in our online communities.
Travel to Melbourne and network with thousands of peers!
Check out what's new in the Power BI Community!