Calculate measure against unrelated date table?

[jd8766]

Hello, does anyone know if the below is possible?

I have 2 tables like the below, the one on the left is my payment table and the one on the right is my forecast table. Both are related to their own DIM.Date tables..

I have a visual at the moment that shows a line graph for the forecasted amount..

However I want to add a separate line showing the amount from the payments table so I can see the performance of actual payments vs what we forecasted, 

Is there a way I can do this via a measure? Appreciate your help as always..

[PaulDBrown]

Try:

Payment = CALCULATE(SUM(Payment[Amount]), TREATAS(VALUES(Dim Forecast Date [Date]), Payment [Date]))

If in the visual you are using the date field from the forecast table directly, adjust the VALUES expression accordingly.

Out of curiosity, why do't you have a single date table? 

[mh2587]

 measure = sum(tableName(Amout))

[jd8766]

I tried this.. it doesn't work as the 2 tables aren't related

[mh2587]

Then try this

measure = 

CALCULATE(

    sum(tableName(Amout)),

    TREATAS(VALUES(Table1[PaymentID]),Table2[PaymentID]))

[jd8766]

Hmm... still doesn't seem to work. I think it needs to be anchored on both the paymentid and the date.. so that the amount from table 1 on the 1-feb-2022 can be seen against the same date in the 2nd table.. if that makes sense. I just can't get my head around the best way of doing this.

[m3tr01d]

hi @jd8766 ,

on your chart, are you using the date from DimDate or from of the two tables?
You should be using the field from the dimension.