Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I have a table with two columns, for the sake of the example they'll be called Name and Date
Below is a sample of that table
Name | Date |
a | 1/1/2024 |
a | 2/1/2024 |
a | 3/1/2024 |
b | 5/4/2024 |
b | 5/5/2024 |
c | |
d | |
e | |
f | 6/6/2024 |
f | 6/7/2024 |
I want to show only the Latest Date by Summarizing the column
But at the same time I don't want to hide the blank rows so my final table should look like this
Name | Date |
a | 3/1/2024 |
b | 5/5/2024 |
c | |
d | |
e | |
f | 6/7/2024 |
Any suggestions on how to achieve that will be appricated.
Thank you.
Solved! Go to Solution.
Hello @samerhajjar ,
you add it to a table or matrix and you click on the drop down on the name field and check the show items with no data and the blanks will show.
Proud to be a Super User! | |
Hello @samerhajjar ,
you add it to a table or matrix and you click on the drop down on the name field and check the show items with no data and the blanks will show.
Proud to be a Super User! | |
User | Count |
---|---|
77 | |
74 | |
62 | |
61 | |
45 |
User | Count |
---|---|
108 | |
102 | |
93 | |
83 | |
64 |