topic Re: Sum data based on product availability by comparing years. in DAX Commands and Tips

Sum data based on product availability by comparing years.

Sudharsanan — Wed, 27 Jul 2022 11:42:13 GMT

Hi All,

Can someone help me with the below scenerio?

I wanted to sum the price when the product is available on both 2022 and 2021? is this something we can get using DAX?

Appreciate your support!!

Re: Sum data based on product availability by comparing years.

SpartaBI — Wed, 27 Jul 2022 12:04:21 GMT

Sudharsanan what is the result you want to get in the measure?
25 + 35 + 45 ? or also the valus from 2022? 5, 10 and 20?

Re: Sum data based on product availability by comparing years.

Sudharsanan — Wed, 27 Jul 2022 12:06:57 GMT

SpartaBI i need 25+35+45 from 2021 alone

Re: Sum data based on product availability by comparing years.

SpartaBI — Wed, 27 Jul 2022 12:19:23 GMT

Sudharsanan

Result = VAR _filter = INTERSECT( CALCULATETABLE(VALUES('Table'[Customer]),'Table'[Year] = 2021), CALCULATETABLE(VALUES('Table'[Customer]),'Table'[Year] = 2022) ) RETURN CALCULATE( SUM('Table'[Price]), 'Table'[Year] = 2021, _filter )

Showcase Report – Contoso By SpartaBI

Re: Sum data based on product availability by comparing years.

Sudharsanan — Wed, 27 Jul 2022 12:54:21 GMT

SpartaBI I am getting the below error and not able to get the answer..can you help me with it?

Re: Sum data based on product availability by comparing years.

SpartaBI — Wed, 27 Jul 2022 13:04:25 GMT

Sudharsanan you didn't share the screenshot or I can't see it for some reason

Re: Sum data based on product availability by comparing years.

Sudharsanan — Wed, 27 Jul 2022 13:13:10 GMT

am sorry SpartaBI the error is not showing now which was related to values..somehow i fixed it..but the result is blank now

Re: Sum data based on product availability by comparing years.

SpartaBI — Wed, 27 Jul 2022 14:31:17 GMT

Sudharsanan hey friend, will be back to desk in few minutes. Do you want to do a quick zoom?

Re: Sum data based on product availability by comparing years.

Sudharsanan — Wed, 27 Jul 2022 14:44:12 GMT

SpartaBI thats should be better..let me know how can i connect?

Re: Sum data based on product availability by comparing years.

SpartaBI — Wed, 27 Jul 2022 14:50:43 GMT

Sudharsanan can you join now?
https://us05web.zoom.us/j/82871748787?pwd=bFBCenRWK1g4ZkhWR3U4cndvUmtXQT09

Re: Sum data based on product availability by comparing years.

Sudharsanan — Wed, 27 Jul 2022 15:01:28 GMT

SpartaBI meet.google.com/kbh-uyud-dvz