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 i need 25+35+45 from 2021 alone
- SpartaBI
Community Champion
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- Sudharsanan
SpartaBI I am getting the below error and not able to get the answer..can you help me with it?
- SpartaBI
Sudharsanan you didn't share the screenshot or I can't see it for some reason