Calculate MAX and MIN date sale value using DAX? Hi All can you help me with below

[swapnareddy]

Date                     sale

01-jan-2020         500

01-jan-2020         1000

02-jan-2020         2000

31-jan-2021         1000

20-feb-2021         100

20-feb-2021         200

Expected output using DAX

Mindate 01Jan 2020 sale 1500

Maxdate 20feb 2021 sale 300

[ValtteriN · Accepted solution]

Hi,

Try something like this:

Var _maxdate = calculate(max(table[date]),all(table[date]))
Return

Calculate(sum(table[sale]),all(table[date]),table[date]=_maxdate)




Var _mindate = calculate(max(table[date]),all(table[date]))
Return

Calculate(sum(table[sale]),all(table[date]),table[date]=_mindate)



I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!

My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/