DAX Studio is an opensource data analysis tool to write, execute, and analyze DAX queries in Power BI Designer, Power Pivot for Excel, & Analysis Service.