Replicate value for group of rows

[IvanS]

Dear all,

I would need your help with coping values within one column for group of rows. In my case, I have invoice represented by Document_No. Our accounting system is spliting invoice into several entries (revenue, VAT and payment).

What I want to achieve - if payment date/closing date of at least one entry within the gropu is not blank, then to replicate this date to remaining rows within the group. Group is defined by entries having identical Document_No.

Please find below example:

Thank you
Ivans

[IvanS]

Hi @rsbin ,

it is working just perfectly when I create calculated column in Invoice table using RELATED(Payments[OriginalDate]).

However, when I try to add RELATED to your function I got following error: 
The MAX function only accepts a column reference as an argument.

Is there any way how to avoid this error and achieve the same result without creating additional columns in my Invoice table?

Thank you!

Ivans

[rsbin · Accepted solution]

@IvanS ,

You can create a new Calculated Column:

RevisedDate = CALCULATE( MAX( [Payment date/Closing date] ),
                       ALLEXCEPT( Invoices, Invoices[DocNo] ))

Hope this helps.

Regards,