Duplicate remove issue

[Anchor_Appadmin]

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 · Accepted solution]

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

[Anchor_Appadmin]

wow…Perfect for my problem

[Aleksi]

You’re welcome

[Anchor_Appadmin]

Hi,

Could you please help me to sort the month correctly.

I have extracted the month and year from date column based on the below formula

TEXT([Complaint Closed Date],“mmmm-yyyy”)

[Aleksi]

Because the sort is made as a string, you need to write it like 2020-01-January

[Anchor_Appadmin]

I have created for monthly reports but while inserting this formula its showing date wise. Please help!

Screenshot_20201012-171047_AppSheet|225x500

[Aleksi]

Sorry, for some reason I have missed your reply. The format 2020-Wed-January won’t work because after the order is sorted with the 2020 your view start the ordering from the first letter “W”.

[Anchor_Appadmin]

its ok,

i have spited in to year and month, Then grouped .