topic Re: Calculate MAX and MIN date sale value using DAX? Hi All can you help me with below in DAX Commands and Tips

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

swapnareddy — Thu, 24 Feb 2022 11:00:36 GMT

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

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

ValtteriN — Thu, 24 Feb 2022 11:22:24 GMT

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/