Full Outer Join in DAX in PowerBI

Full Outer Join

According to Wikipedia -

“Conceptually, a full outer join combines the effect of applying both left and right outer joins. Where rows in the FULL OUTER JOINed tables do not match, the result set will have NULL values for every column of the table that lacks a matching row. For those rows that do match, a single row will be produced in the result set (containing columns populated from both tables).”

So, the Full Outer Join can be acheived by creating -

• Left Outer Join
• Right Anti Join

  Exception handling in Python

• Try and Except
  • Handle Exceptions
  • Exceptions Attributes
  • Handling Multiple Exceptions
• Else
• Finally

Try and Except

• Handle Exceptions

  The following statement will throw an error as string can’t be parsed into integers.

hello = "hello world"
print("Converting string to int")
print(int(hello))
print("Done!")

  Functions in Python - return, scope, args and kwargs

• Return in Function
• Scoping in Function
  • Access global variable in function context
  • Declare a local variable within in a function
  • Declare local variable with same name as in global
  • Using Global Keyword
• *args and **kwargs in function