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
Solved! Go to Solution.
Try…
[_THISROW] = MAXROW(“Trip”, “_ROWNUMBER”,
AND(
[_THISROW].[Customer] = [Customer],
EOMONTH([Date],0)=EOMONTH([_THISROW].[Date],0)
)
)
Try…
[_THISROW] = MAXROW(“Trip”, “_ROWNUMBER”,
AND(
[_THISROW].[Customer] = [Customer],
EOMONTH([Date],0)=EOMONTH([_THISROW].[Date],0)
)
)
wow…Perfect for my problem
You’re welcome
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”)
Because the sort is made as a string, you need to write it like 2020-01-January
I have created for monthly reports but while inserting this formula its showing date wise. Please help!
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”.
its ok,
i have spited in to year and month, Then grouped .
User | Count |
---|---|
43 | |
28 | |
23 | |
14 | |
14 |