return max date from mulitple colums only if all 4 columns have a date present

[C097986]

Hey guys,

       so i researched all over and i cannot get this formula to work.

I'm trying to get a date that shows the max date from 4 different columns, only if all 4 columns have dates present in them.

what i get is that i can get the max date of the 4 columns regardless if all 4 columns are completed or not.

for eg.

so like you see in this picture, if there are 3 dates completed or even 1 date completed, it still give me a result in the last column. i only want it to give a result if all 4 columns are completed.

how can i alter this formula? any help would be appreciated.

Final_Approved_Time = Max(Max(AEF_REQUEST_FORM_DATA[PAIImpApproved],AEF_REQUEST_FORM_DATA[SAImpApproved]),Max(AEF_REQUEST_FORM_DATA[RGImpApproved],AEF_REQUEST_FORM_DATA[CIImpApproved]))

[Greg_Deckler]

Use my MC Aggregations Quick Measure and insert a COUNTROWS check to make sure that you have 4 rows.

https://community.powerbi.com/t5/Quick-Measures-Gallery/Multi-Column-Aggregations-MC-Aggregations/m-...

[C097986]

i came across another problem when i use this formula to achieve the above problem.

Final_Approved_Time = IF(AEF_REQUEST_FORM_DATA[STATUS]="Approved",Max(Max(AEF_REQUEST_FORM_DATA[PAImpApproved],AEF_REQUEST_FORM_DATA[SAImpApproved]),Max(AEF_REQUEST_FORM_DATA[RGImpApproved],AEF_REQUEST_FORM_DATA[CIImpApproved])),0)

this is the data that i get when i use the above formula. As you can see that it gives me the right value when all 4 colums are filled: 7/10/2018. But when it's any other case, then it just give me a generic value of 12/30/1899. i put in the formula that i want to see a 0 or even blank is ok instead of this value, but i dont know where i went wrong.

can anyone help me through this?

thank you in advance.

[C097986]

thank you. this helped a lot. i aggregated, then used a count with a max. it worked. thank you