Merge in a single Line Chart two visuals with different dates columns

Hi Anonymous ,

I suggest you to create a virtual table in var and then calculate the running total.

My measure:

IFD_Actual = 
VAR _VIRTUAL_TABLE =
    ADDCOLUMNS (
        ALL ( 'Date 1' ),
        "TEST",
            CALCULATE (
                COUNT ( 'MODEL 60'[IFD Actual] ),
                USERELATIONSHIP ( 'MODEL 60'[IFD Actual], 'Date 1'[Date] )
            )
    )
RETURN
    SUMX ( FILTER ( _VIRTUAL_TABLE, [Date] <= MAX ( 'Date 1'[Date] ) ), [TEST] )

In my sample, [Date] column in my table visual is from 'Date 1'. So the filter in sumx is [Date] (from virtual table) <= MAX('Date1'[Date]).

Note: We need to add the [Date] column in table visual in Max field in sumx filter.

Best Regards,
Rico Zhou

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