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
SpartaBI
Community Champion
Community ChampionSudharsanan you didn't share the screenshot or I can't see it for some reason
SudharsananHelper III
Helper IIIam sorry SpartaBI the error is not showing now which was related to values..somehow i fixed it..but the result is blank now
- SpartaBI
Sudharsanan hey friend, will be back to desk in few minutes. Do you want to do a quick zoom?
- Sudharsanan
SpartaBI thats should be better..let me know how can i connect?
- SpartaBI