Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Find the value based on Comma seperated list

I have a Table - 1 with a path (comma seperated value) of everyone who reports to someone Table 1 Column1 - value A,B,C example : A,B,C where A and B reports to C   Another Table , Table 2 which ...
Need Help
v-lid-msft's avatar
v-lid-msft
Community Support
7 years ago

Hi Anonymous ,

 

We can create this column in tables to show who to report.

 

Report man = 
MAXX (
    Table2,
    IF (
        FIND ( [Level], [Column1], 1, -1 )
            = (
                LEN ( [Column1] ) - LEN ( [Level] ) + 1
            ),
        [Level]
    )
)

 

Then we can create such column to show the sub people.

 

Sub People =
VAR t =
    FILTER ( 'Table', [Level] = [Report man] )
VAR result =
    MAXX (
        t,
        REPLACE (
            [Column1],
            LEN ( [Column1] ) - LEN ( [Level] ),
            LEN ( [Level] ) + 1,
            ""
        )
    )
RETURN
    SUBSTITUTE ( result, ",", " & " )

 

But I connt get the point of the meaning of “Amount”.

 

If it doesn't meet your requirement, kindly share your sample data and excepted result to me if you don't have any Confidential Information. Please upload your files to One Drive and share the link here.

 

BTW, pbix as attached.

 

Community Support Team _ DongLi
If this post helps, then please consider Accept it as the solution to help the other members find it more