Conditional Nested IF Statement

Hi Sidzx6r - Create a new column as below to check on scheduled date.

 

 

you can join the calendar and schedule tables based on date column 

 

Create merged table reflects the correct structure and that the conditional column shows "NoProgress" for dates without scheduled entries. 

 

Hope it works. 

 

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!

Sidzx6r 
Alternatively to rajendraongole1 's solution, you can use a Switch function as below; the advantage of the Switch function is lower complexity and highly increased scalability (multiple conditions with ease of configuraiton):

 

New Conditional = 
SWITCH(
    TRUE(),
    ISBLANK(Sheet1[Scheduled Date]),"InProgress",
    Sheet1[Scheduled Date]="null","InProgress",
    Sheet1[Conditional]
)

 

In your example, you don't really need the "null" statement but I put it there just in case you encounter it in your data model. You can use as many conditions as you need (including && operators, for example for the Type B Products).

 

Best,

 

Sidzx6r it would be great if you marked an answer as the solution to your problem so other users can see it.

 

Best,