Getting the new column

[Saravanan_ameer]

Dear Expects,

I have the table from SQL pulled the data like i have applied the logic.  Column name called "Leave status" in that if the employee is absent it will check another table for the leave applied or and it will give the result.

Now the requirement is if the employee is absent then i need to check another sharepoint table also to check the if the employee applied any emercency leave or not.

 basically i need to compare the SQL table & shrepoint table in power bi then give the output.

example: If the employee leave status is Absent and for the selected date if the employee applied leave (I need to compare the start date and end date in that share point table) then the resulf will emerncy leave applied or else not applied.

share point table

sql:

[MFelix]

Hi @Saravanan_ameer,

When you refer you need a new column do you need it on the model or on a visualization?

[Saravanan_ameer]

I need it in model so that i can use anywhere in the report