Forum Discussion
DAX function to count values not duplicated
Hi all, I am running a report for a wharehouse to check what is inside, what was removed and what has entered. I want to focus on what was removed from one day to another and exclude what en...
Hi marquesj ,
1. The expression of column 2 can be modified as:
Column 2 =
IF('Table'[Column] = BLANK(),1,BLANK())2. Create a calculated column to count new values.
Column 3 =
VAR _cou = CALCULATE(SUM('Table'[Column 2]),FILTER(ALL('Table'), 'Table'[Column 2] <> BLANK()&&'Table'[Date Dwell] = EARLIER('Table '[Date Dwell]) ))
RETURN
IF('Table'[Column 2] <> BLANK(),_cou,BLANK())
3. The final result is shown in the figure below. All data are displayed on March 5 because there is no previous date for comparison, so all data are considered new.
If your Current Period does not refer to this, please clarify in a follow-up reply.
Best Regards,
Clara Gong
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
HI Anonymous
It seems that isn't working. Dwell days are not contemplated and it's counting only the unique packages of day 6/03. If I manually put the filter on the visual for "Dwell = 0" I'm left with very few results which don't match the reality