Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Helper III
Helper III

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

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.

Community Support
Community Support

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.

Hi @v-stephen-msft ,


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.

Helpful resources

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors