How to add the Group by Account with MIN(Start date) & MAX(End Date)?

[Zack92]

Hello, 

I am not super familiar with this type of dax, but I am trying to add a group by Account with Min(Start Date) and Max(End date). 

Can anybody please guide me in the right direction? 
My Code

DEFINE
	VAR	Tracker =
		SELECTCOLUMNS (
			df_ProServUtilizationTracker,
			"UID",'df_ProServUtilizationTracker'[UID] & "",
			"Consultant Email",'df_ProServUtilizationTracker'[Owner],
			"Subject",'df_ProServUtilizationTracker'[Subject],
			"Category",'df_ProServUtilizationTracker'[Primary Categories],
			"Consultant",'df_ProServUtilizationTracker'[sp_Employees.Name],
			"Start Date",'df_ProServUtilizationTracker'[Start],
			"End Date Orig",'df_ProServUtilizationTracker'[EndOriginal],
			"End Date",'df_ProServUtilizationTracker'[End]
		)
	VAR Subject =
		SELECTCOLUMNS (
			df_ProServUtilizationSubj,
			"UID",'df_ProServUtilizationSubj'[UID] & "",
			"Account",'df_ProServUtilizationSubj'[Account],
			"Deployment Type",'df_ProServUtilizationSubj'[DeploymentType],
			"Scope",'df_ProServUtilizationSubj'[Scope],
			"PM",'df_ProServUtilizationSubj'[PM],
			"Location",'df_ProServUtilizationSubj'[Location]
		)
EVALUATE
    FILTER (
        FILTER (
            NATURALINNERJOIN ( Subject , Tracker ),
            CONTAINSSTRING( [Scope] , "Upgrade" )
        ),
        OR (
            OR (
                OR (
                    CONTAINSSTRING( [Deployment Type] , "HA" ),
                    CONTAINSSTRING( [Deployment Type] , "DR" )
                ),
                CONTAINSSTRING( [Deployment Type] , "Enterprise" )
            ),
            CONTAINSSTRING( [Scope] , "Enterprise" )
        )
    )​

I tried adding the below code for the bottom, did not work 

EVALUATE
    SUMMARIZE (
        FILTER (
            FILTER (
                NATURALINNERJOIN ( Subject , Tracker ),
                CONTAINSSTRING( [Scope] , "Upgrade" )
            ),
            OR (
                OR (
                    OR (
                        CONTAINSSTRING( [Deployment Type] , "HA" ),
                        CONTAINSSTRING( [Deployment Type] , "DR" )
                    ),
                    CONTAINSSTRING( [Deployment Type] , "Enterprise" )
                ),
                CONTAINSSTRING( [Scope] , "Enterprise" )
            )
        ),
        [Account],
        "Min Start Date", MIN([Start Date]),
        "Max End Date", MAX([End Date])
    )​

Note - I am using this Dax code in Power Automate. 

Thank you so much 

[lbendlin]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...