Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Left Join between tables for Not present values in Power BI

I have two tables "Projects" and "Issues". Both the tables have the similar field as Project ID.

 

If there are 10 projects present in Projects table with unique 10 Project IDs, the the Issues table may contain issues for around 5 projects which has respective issues related to it.

 

Now I have a calculated column in Issue tables to get some color fields which is given as formula to other rectangle shape components in reports. Those components does not works for other 5 projects which are not present in Issues tables. I need to handle it by giving some other values for not present values ? How to do this ?

  • You do this by specifying BLANK() for that branch of the decision tree.

2 Replies

  • You do this by specifying BLANK() for that branch of the decision tree.