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.

Greg_Deckler's avatar
Greg_Deckler
Community Champion
6 years ago

jereaallikko - If I am understanding this correctly, you would want your dataset laid out like this:

 

Priority Subtask Work Place Estimated Hours Work Hours Remaining Hours
BM-00 New furniture in basement New sofa ...        
BM-00 New furniture in basement Fridgerator for beverages, snacks        
GF-101 Renovating specific rooms from the ground floor GF101 New oven, coffee machine...