DiLytics interview question

sql joins , powerbi dax , excel functions