Identify minimum date and assign it to records with the same Internal Number

[Syndicate_Admin]

Good morning.

I would like to generate some DAX that allows me to identify the minimum date within the "Accountingdate" field as long as the voucher is V and the Internal Number is the same. In the example:

For the internal number C-ME-00000091 the minimum accounting date within the V vouchers is 02/06/2021 (red in image)

For the internal number C-ME-00000117 the minimum countable date within the vouchers V is 02/06/2021 (blue in image)

I hope it is understood and whoever has any solution, can help me.

Thank you very much.

[Syndicate_Admin]

Excellent! It worked, thank you so much for your help!

[onurbmiguel_]

Hello 

Try this measure: 

Fecha Min = 
CALCULATE(
    min('Table'[Fechacontable]),
    GROUPBY('Table','Table'[Numero interno],'Table'[Comprobante]),
    'Table'[Comprobante]="V"
)

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!! ;-
Best Regards
BC

[Syndicate_Admin]

It's a great approximation, but I was looking for this:

That each record contains the date min. With the measure introduced, it gives me the same date as the Accounting date. To the right of the Date min column, I placed what I'm looking to get to.

Best regards.

[onurbmiguel_ · Accepted solution]

Hi again. 

Sorry you're right.

try this measure: 

Fecha min = 
var _numero = SELECTEDVALUE('Table'[Numero interno])
var _value = 
    CALCULATE(
        MIN('Table'[Fechacontable]),
        filter(all('Table'),'Table'[Numero interno]=_numero && 'Table'[comprobante] = "V")
    )
return 
_value

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!! ;-
Best Regards
BC

[Syndicate_Admin]

Excellent! It worked, thank you so much for your help!

[onurbmiguel_]

Hello 

Please accept my solution and and give me kudos if possible.

thanks 

Bruno 

[Syndicate_Admin]

Hello Bruno!

I believe that the solution has already been accepted. I'm new to the platform.

And congratulations are given from where?

Best regards.