Forum Discussion

Frequent Visitor

8 years ago

Solved

Dynamic Group Data Working with Date Slider

Hi all, In a previous post (click here) You all helped me combine sales teams with their respective subteams. I now need to take that same approach and have those sales numbers work with a Date s...

Need Help

Zubair_Muhammad

8 years ago

Hi Bridgewater

Try this calculated Table.

Then add a Date Slider using Date Column from this Calculated Table

New Table =
VAR TeamTable =
    SUMMARIZE (
        TableName,
        TableName[Team],
        TableName[Date],
        "Amount", SUM ( TableName[Amount] )
    )
VAR SubTeamTable =
    FILTER (
        SUMMARIZE (
            TableName,
            TableName[Sub Team],
            TableName[Date],
            "Amount", SUM ( TableName[Amount] )
        ),
        TableName[Sub Team] <> BLANK ()
    )
RETURN
    UNION ( TeamTable, SubTeamTable )