Creating Trends Over time

Not clear what the message is that you want to convey. Please elaborate.

 

 

 

 

Hi powellar ,
Here are some steps you can try
Sample data
Table 1

Date	Poam
8/21/2024	Poam1
8/21/2024	Poam2
8/28/2024	Poam3
8/28/2024	Poam4
8/28/2024	Poam5
9/4/2024	Poam6
9/4/2024	Poam7
9/4/2024	Poam8
9/4/2024	Poam9
9/11/2024	Poam10
9/11/2024	Poam11

Table2

Date	Poam
8/21/2024	Poam1
8/21/2024	Poam2
8/21/2024	Poam3
8/28/2024	Poam4
8/28/2024	Poam5
8/28/2024	Poam6
9/4/2024	Poam7
9/4/2024	Poam8
9/11/2024	Poam9
9/11/2024	Poam10
9/11/2024	Poam11

Create measures

Difference = 
VAR _count = 
CALCULATE(
    COUNT('Table 1'[Date]),
    ALLEXCEPT(
        'Table 1',
        'Table 1'[Date]
    )
)
VAR PreviousCount = 
CALCULATE(
    COUNT('Table 1'[Date]),
    ALLEXCEPT(
        'Table 1',
        'Table 1'[Date]
    ),
    DATEADD('Table 1'[Date], -7, DAY)
)
RETURN
IF(
    ISBLANK(PreviousCount),
    _count,
    _count - PreviousCount
)

NextDifference = 
VAR NextDifference = 
CALCULATE(
    [Difference],
    ALLEXCEPT(
        'Table 1',
        'Table 1'[Date]
    ),
    DATEADD('Table 1'[Date], +7, DAY)
)
RETURN
IF(
    NextDifference = BLANK(),
    0,
    NextDifference
)

IsBreakingPoint = 
IF(
    [NextDifference] <= 0 && [Difference] >=0 || [NextDifference] >= 0 && [Difference] <=0 ||
    SELECTEDVALUE('Table 1'[Date]) = 
    CALCULATE(
        MAX('Table 1'[Date]),
        ALL('Table 1'[Date])
    ) ||
    SELECTEDVALUE('Table 1'[Date]) = 
    CALCULATE(
        MIN('Table 1'[Date]),
        ALL('Table 1'[Date])
    ),
    "Black",
    "White"
)

The above MEASURE is to determine if the point is a turning point or both ends of the end point
Enable datalables and apply the measure to value color

Final output

In order for multiple tables to be realized on the same line chart, you need to create relationships between the tables

Best regards,
Albert He

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