Max and Select Error in Detailed View

[Eoj_VT]

Good Day.

I am having a regular" table 1" column [Date Till Paid]. This column is having a formula base on the input of other table.“Payments Table”

Max(Select(Payments[Payment To], [Contract No.] =[_ThisRow].[Contract No.]))

This formula works fine only when a user is adding a new row on the reference table “Payments”

The issue is:

When a user edit this column [Payment To] from the reference table. The table 1 [Date Till Paid] detail view is not updating. You can only view the updated value if you are in edit mode or form view.

Any help

[Aurelien]

Hi @Eoj_VT

Is it a real column (vs a virtual column ?)
If so, you may want to change it using a virtual column instead.
Real column formulas are only calculated when edited (to make it simple).

If not, can you please share your table structure where you have this column ?
Screenshot are best
Thank you

[Aurelien]

Aurelien:

Real column formulas are only calculated when edited (to make it simple).

@Eoj_VT

May that be the answer to your situation ?
Did you try using virtual column instead ?

[Eoj_VT]

Works with VC. Thanks

[Eoj_VT]

@Aurelien thanks. Its a normal column. I updated my post above