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
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.
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.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
110 | |
109 | |
108 | |
93 | |
61 |
User | Count |
---|---|
171 | |
139 | |
133 | |
102 | |
86 |