Skip to main content
Topics#Tableau Desktop & Web AuthoringTableau Community Forums Member (Inactive)'s Question
Tableau Community Forums Member (Inactive) (Salesforce) asked in #Tableau Desktop & Web Authoring
Aug 26, 2021, 12:27 AM

Maximum Date Based on a Boolean Column

Maximum Date Based on a Boolean ColumnI need to populate Move Out Date which would be max of moveoutdate for a fixed container and erp group and penisstepcomplete is true,

 

H11263 Move Out Date should be Null as the step is not comleted

Rest for All Containers and ERP Group there should be Max(moveoutdate) value in Move Out Date.

 

I am not able to figure out the solution

1 answer
  1. DIEGO FERNANDO MARTINEZ RODRIGUEZ (Modux)
    Aug 26, 2021, 12:43 AM

    @Vishal Reddy​ 

    Hi, you can use:

    {FIXED [Container N],[ERP Group]:MAX(IF [PenisStepComplete] THEN [MoveoutDate] END)}

    If this post resolves. would you be so kind to "Select as Best"?. This will help other users find the same answer/resolution and help community keep track of answered questions. Thank you.

     

    Regards,

     

    Diego

Write an answer...
0/9000