Using combined data from two columns

[TTPP81]

How do I create a timeline in a gantt chart using combined data from two columns? Can someone helpful please tell me the codes / measures / conditions that I should use?

Refer to picture attached.

A Family Model (column 1) only requires one review check regardless how many model names they contain. In this case, "Credit Family Model" is the main family for the three models "Credit 1 model", "Credit 2 Model" and "Credit 3 Model" so it only requires one review check. If a Model name (column 2) does not have a Family name (N/A in Family column), then it will count as one review check. In the first table, there is a total of 7 review checks because there are 3 Family models and 4 Model Names without a family model. 

@BA_Pete 

[Omid_Motamedise]

Why tge date for the frequency check model is changed to 1/3?

[BA_Pete · Accepted solution]

Hi @TTPP81 ,

I may be misunderstanding the requirements, but it seems as though you can just create a new [Total Check] column using the following code:

if [Family] = "N/A" then [Model Name] else [Family]

You can then use this new column to Group By.

Depending on how [Date] and [Team] get populated in the full data (duplicated [Total Check] per [Date]/[Team] etc.) you can use different aggregated columns for [Date]/[Team].

Pete

[TTPP81]

thank you, it worked now as I replace blanks to N/A