I have connected (Blending) two data files with. One includes all sales per product and the second one includes only Product numbers on new products.
What I would like to do is to use the second file as a filter. So I can automatically look at only products that is is in the second file.
I thought this was possible with an IF statement like
IF Product = file2(Product) THEN Product
And then use this calculation to bring in date or any other things.
Hope there is a way to solve my question
Solved it with the following calculation
IF ATTR([Item_Number]) = ATTR([New products (New Products EMEA 2018-11-21)].[Item_Number]) THEN 'New' ELSE 'Old'