Forum Discussion

PBIBeginner2022's avatar
PBIBeginner2022
Helper III
4 years ago

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.

Data Protection
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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's avatar
      PBIBeginner2022
      Helper III
      4 years ago

      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.