I have a data table wherein I want to sum sales amount based on minimum amount.

[Anonymous]

I have a below table as

Date                Sales      Required Column (Sum with min date)

1-1-2020         100        100

1-2-2020          200        100

1-3-2020         300          100

1-4-2020         400         100

Kindly write dax for above.

[Anonymous · Accepted solution]

I have got the answer to this, var abc=calculate(min(date), all(date) return calcualte(sales,filter(allselected(date), date=abc)

No more help required.

[amitchandak]

@Anonymous , Try

firstnonblankvalue(Table[Date], Sum(Table[Sales]))

[Pragati11]

Hi @Anonymous ,

You can simply create a measure:

MinValue = CALCULATE(MIN(Tablename[Sales]), ALL(Tablename))

Replace Tablename with your tablename in above dax expression.

Thanks,

Pragati

[Anonymous]

This is simply wrong, I dont want the min amount I want amount in all the rows as per the min date.