Show oldest and most recent dates

[AlexisPREVOT]

Hi,

I want to display a table with the oldest and most recent dates of each billing.

For example, for my XXX client, I want to see that the first billing took place on 01/01/2020 and the last billing on 07/01/2021.

I therefore created a table with my first invoice date (by selecting "the oldest" in the values ​​"and the name of my customers.
But I can't display the last invoice date.
I tried to make a column like this: colonne = firstdate(factures[dates].[dates]) but it does not work.

If anyone has an idea i will be very grateful.

Thank you by advance.

Alexis

[ryan_mayu]

@AlexisPREVOT 

maybe you can try

min(factures[dates])

if you can provide the sample data and expected output , that will be better for us to provide the proper solution

[AlexisPREVOT]

Hi @ryan_mayu ,

I tested the formula but it also doesn't work.
This is what I want to achieve (boxed in red, it's a photo montage for the example ) :

So, in my first column I do have my oldest billing date : 

I therefore want to concatenate in the same table the oldest date of my invoice and the most recent date.

I hope this will help you ti help me.

[ryan_mayu · Accepted solution]

@AlexisPREVOT 

maybe try this

calculate(max(fact[dates]),allexcept(table, FCC_ID))

since the screenshot is not clear, you need to modify the DAX based on your real table and column name.

[AlexisPREVOT]

Thank you for the response but unfortunatelley it doesn't work

[ryan_mayu]

@AlexisPREVOT 

could you pls provide the sample data and expected output?

[AlexisPREVOT]

Sorry i just retested and it works, i was the one who made a mistake in the formula. All my excuses.

Thanks for your help

[ryan_mayu]

you are welcome