Forum Discussion
Solved
show only the minimum value in a table visual
Hi all, I've a table like this, I want to show customer name with the minimun days left only so for here it will show x = 4, y = 9 and z = 5 it can be done using group by but I need to make it...
Mai_Nashaat
You can insert a Table Visual add Customer then you can create the following measure and add it.MinDays = min( TABLE[days left] )
Mai_Nashaat
You can insert a Table Visual add Customer then you can create the following measure and add it.
MinDays = min( TABLE[days left] )
yes it's done, another question please I want to add column status that when the left days is less than 0 it write it's status on hold I made it like if(MinDays <0,"onhold",MinDays)
but when I add it to the table with customer name it shows all the days left again not the minimun only.
how can I do it?
yes thank you very much 🙂