Sum of value for min date

[alec1982]

hi,

on a table I have Date Column and then a value column and also a column with flag

on a table chart, I want to have Date, Min Date, Sum values, Value on Min Date.

I used

Sum(if(Flag = 1 and [Date]= Min(Total <[Date]> [Date]),[Value])) to show value of the minimum date but getting null.

Anyone can help.

Thanks

[swuehl]

Try

=Sum( {<Flag = {1}, [Date] = {'$(=Date(Min({<Flag = 1>}[Date])))'}>} Value)

[alec1982]

Thanks Stefan. it still shows null values

[swuehl]

Are your dates correctly interpreted as such?

Could you upload a small sample?

Why don’t my dates work?

Dates in Set Analysis

[alec1982]

When using the following formula in a column

if(Flag = 1 , Min(Total <[Date]> [Date]))

I get the right date and the format in MM/DD/YYYY

Thanks again

[swuehl]

What is the chart context (dimensions used)?

[alec1982]

The Date Column and it looks like this

date(if(Flag = 1 , [Date]),'MMM YY')

[alec1982]

Still struggling with it.. Anyone can help.

[#9]

assuming you are using this in a chart and the chart is ordered by Date, can you try this.

Sum(if(Flag = 1 and [Date]= FieldValue('Date',1), Value)

[alec1982]

it gives null value