Maximum count every single month for each unique customer

Hi okiedokie2017,

If I understand you correctly, you should be able to follow steps below to get the expected result in your scenario.

1. Use the formula below to add a YearMonth column in table 'system_monitored'.

YearMonth = YEAR(system_monitored[Original Timestamp])*100+MONTH(system_monitored[Original Timestamp])

2. Then you should be able to use the formula below to create the expected table. 

Table = 
SUMMARIZE (
    system_monitored,
    system_monitored[YearMonth],
    system_monitored[users.customers ],
    "Max Configured per Month", CALCULATE ( MAX ( system_monitored[Configured] ) ),
    "Date",
    VAR abc =
        CALCULATE ( MAX ( system_monitored[Configured] ) )
    RETURN
        CALCULATE (
            MAX ( system_monitored[Original Timestamp] ),
            system_monitored[Configured] = abc
        )
)

Here is the sample pbix file for your reference. :smileyhappy:

Regards