How to extract date when sales value reach exactly 100k?

[anindya_manna]

Hello Experts,

I am creating a chart with the columns id ,name ,sales,100K break date.I want to show id and names whose sells more than or equal to 100k and also the aook break date in which it exactly touch 100k milestone.

How to do it in a single table?

[shiveshsingh]

Please share your app, you can put conditional dimension to counter this requirement

[YoussefBelloum]

Hi,

you can add an expression for the date, like this:

=only( {<Measure={"sum(Measure)=100000"}>}  date_field)

[anindya_manna]

This is not working.This is my expression but it is not working.

only({<[Sales Amt]={"sum([Sales Amt])=10000"}>}[Process Date])

[YoussefBelloum]

My bad.. try this

=only( {<Measure={"=sum(Measure)=100000"}>}  date_field)

[YoussefBelloum]

only({<[Sales Amt]={"=sum([Sales Amt])=10000"}>}[Process Date])

[anindya_manna]

This is also not working.I am unable to get process date.

[YoussefBelloum]

it is because you don't have a row with [Sales Amt]=100000 on your table.

if you try this, I'm sure you will be able to see some dates

only({<[Sales Amt]={"=sum([Sales Amt])>=100000"}>}[Process Date])

[sasiparupudi1]

Max({<id={'=Aggr(sum([Sales Amt]),id)=10000'}>}[Process Date])

[anindya_manna]

PFA