Forum Discussion
Sudharsanan
Helper III
Helper IIISum data based on product availability by comparing years.
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 su...
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 )
In case it answered your question, please accept the solution to help other members find it. Appreciate Your Kudos.
SpartaBI Logo
Visit SpartaBI website Visit SpartaBI Linkdin Visit SpartaBI Facebook
Showcase Report – Contoso By SpartaBI
SudharsananHelper III
Helper IIISpartaBI thats should be better..let me know how can i connect?
SpartaBI
Community Champion
Community Champion- Sudharsanan
SpartaBI meet.google.com/kbh-uyud-dvz