Solved: Duplicate remove issue - Page 2

Anchor_Appadmin · 10-06-2020 02:42 AM

Hi,

To create a slicer, I want to remove the duplicate customers on monthly basis, I have tried the below formula but the issue is it’s removing all duplicates not considering month. I have the same customer is different months but this formula not considering the month.

([_THISROW] = MAXROW(“Trip”, “_ROWNUMBER”, ([_THISROW].[Customer] = [Customer])))

Could you please help me to resolve the issue?

Please note I have created VC for the month, Daily, etc and Sumif also

Aleksi

Try…
[_THISROW] = MAXROW(“Trip”, “_ROWNUMBER”,
AND(
[_THISROW].[Customer] = [Customer],
EOMONTH([Date],0)=EOMONTH([_THISROW].[Date],0)
)
)

View solution in original post