Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
PBIBeginner2022
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.

 

PBIBeginner2022_0-1655798825961.png

 

 

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

 

PBIBeginner2022_0-1655798597988.png

 

PBIBeginner2022_2-1655796937758.png

 

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

2 REPLIES 2
v-stephen-msft
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)

vstephenmsft_0-1656050428169.png

 

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

vstephenmsft_1-1656050459548.png

 

 

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

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.