Matrix array visual don't function with the two last date in colum

[PBIBeginner2022]

Hi everyone,

I would like create a visual like this photo below with two last two date of my table.

However I don't arrive to create this. I only have one column and not two column as I would like.

I hided confidential information. Could you help me to create the first visual please.

[Anonymous]

Hi @PBIBeginner2022 ,

You want to display the last two dates that exist in the date column.

Here's the solution.

1.Create a rank column.

Rank = RANKX(FILTER('Table',[M/B]=EARLIER('Table'[M/B])),[Date],,DESC,Dense)

2.Add the rank column into the Filters. Set show items when the value is less than or equal to 2.

Best Regards,

Stephen Tao

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

[PBIBeginner2022]

Hi @Anonymous ,

Thanks for your answer but my problem is a little different. 

In my matrix array, I have in line "Make and Buy" in a first table. I have the two lastest (two most recent) extraction date in column of my matrix array in the second table with lots exraction date. And in value I have the sum of all my order wich have a specific status in the third table.

I have 3 different table in my report Power BI. Could you help me again please.