Forum Discussion

jereaallikko's avatar
jereaallikko
Helper III
6 years ago
Solved

How to link rows together in a same table?

Hi all,   I need help with linking rows together based on "Priority". I have created an excel table to visualize the problem;                 I have four "priority" rows (Floor of th...
Need Help
  • Icey's avatar
    Icey
    6 years ago

    Hi jereaallikko ,

     

    How about create a column like so:

    Floor =
VAR MaxEstHours =
    MAXX (
        FILTER ( 'Table', [Level ID] = EARLIER ( [Level ID] ) ),
        [Estimated Hours]
    )
VAR MaxWorkHours =
    MAXX ( FILTER ( 'Table', [Level ID] = EARLIER ( [Level ID] ) ), [Worked Hours] )
RETURN
    CALCULATE (
        FIRSTNONBLANK ( 'Table'[Topic], 0 ),
        FILTER (
            'Table',
            'Table'[Estimated Hours] = MaxEstHours
                && 'Table'[Worked Hours] = MaxWorkHours
        )
    )

     

    Best Regards,

    Icey

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

you could create a new column, extracting the text preceding "-" for each row from the summary column, that is:
BM00
GF101
and so on ...
At this point, use the table.group function on this new column, thus obtaining a sub-table for each group (floor) (*).

IF ... this idea seems to match your needs, but you don't know how to do it, put a table like the one on the screen but in a form that is easily copied and someone will write the code for you.

 

 

(*)

is it possible to grou by in this sense without the auxiliar column, but in this way, I think, is clearer.