Calculated Date field and relating it to a Day table

[NicholeM]

I have a calculated Date field (see below) that I am trying to relate to a Day table, so I can do a Running Total measure (see below)... I have done that measure on a different Day table that is linked to the OCD Date and it works perfect, but for some reason I cannot get the measure to work when using the day table associated with the calculated date. Does anyone know if you can relate two tables by a calculated column and if you can how? 

Date = if(ISBLANK('WELL'[OCD Date]),DATE(1901,01,01),

(MAX('WELL'[OCD Date],'WELL'[FFD Date])))

Running Totol = CALCULATE(CALCULATE(CALCULATE(SUM('JOB'[AMOUNT]), FILTER(ALLSELECTED('Day'[Month Num & Abbr]), ISONORAFTER('Day'[Month Num & Abbr], MAX('Day'[Month Num & Abbr]), DESC))),'Day'[To Date]="Yes"),'Day'[IsCurrentMonth]=0)

[v-xuding-msft]

Hi @NicholeM ,

Did you calculate it out? If yes,  you could share your solution and accept it as a solution. More people will find it quickly and benefit here. If you still need help, please share some sample data and expected results. Then we will understand clearly.

Best Regards,

Xue Ding

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

[v-xuding-msft]

Hi @NicholeM ,

 Based on your formulas, I think your scenario might be a little complex. Could you please share some sample data and expected results? Then we will understand clearly.

Best Regards,

Xue Ding

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