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 )
SpartaBI
Community Champion
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
)
SudharsananHelper III
Helper IIISpartaBI 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
- Sudharsanan
am 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?