Forum Discussion

nicoenz's avatar
nicoenz
Helper III
3 years ago
Solved

Conditional sum in DAX

Hi , i have the the following table: Product Fiscal year Sum of QTY Product A 2021 0 Product A 2022 550 Product B 2021 2947 Product B 2022 2195 Product C 2021 1000 ...
nicoenz's avatar
nicoenz
Helper III
3 years ago
Hi CNENFRNL,
my table also contains data for other years which i would like to ignore. how can i filter them out?
Your DAX includes the data from those "unwanted" years