I have a task, need your help to solve it.
We have two tables, one of them - date and month; second - customer and product ID's, number of line.
Based on one month (february) our goal is to count how many rows do we have in this month but with specific conditions:
1) If data in collum "contract" = "own production", "trading", then we count all those rows seperately as unique ones
2) If data in collum "contract" <> "own production", "trading", then we consider only unique data. For example we have 3 rows with same number 1817, in this case we count only as 1 unique row
In example (february) we have 22 rows. So the goal in our example, considering conditios I mentioned abowe, should be 19 unique rows
Example file pbix
Thank you in advance!
Thank you for your like and decision
Greetings from Ukraine