show only the minimum value in a table visual

[Mai_Nashaat]

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. 

[Fowmy · Accepted solution]

@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] ) 

[Fowmy · Accepted solution]

@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]

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?

[Fowmy · Accepted solution]

@Mai_Nashaat 

You should add it as a Measure, not as a Calculated Column

[Mai_Nashaat]

yes thank you very much 🙂