Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It 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 |
---|---|
98 | |
90 | |
77 | |
71 | |
64 |
User | Count |
---|---|
114 | |
97 | |
95 | |
68 | |
65 |