Forum Discussion
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 in the visual.
any help will be much appreciated.
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] )
4 Replies
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?
