Forum Discussion
Dax Query
Hi, I am comapring last year products with this years products. I have used the below dax code, i filter on the year as we use an accounting week. My problem is we have some old products in 2016 ...
Perhaps have a product table where you do a COUNT for 2017 and 2016 and if the COUNT for 2016 comes back 0, flag that as FALSE, otherwise TRUE. Then you could filter your measure to just TRUE values.