Sajit Simon3 minExcelHow to use DAX in Power Pivot to create calculated Measures & ColumnsData Analysis Expression or DAX in short is a formula expression language which is used by the Analysis Engine of Microsoft. It is used...
Sajit Simon3 minExcelHow to Import Data into Power Pivot & Join 2 or more TablesDid you know that you can create Data Models & establish Relationships between tables in Excel? We can make this possible using a...
Sajit Simon2 minExcelWhat is Power Pivot in Excel & What are its benefits?Power Pivot is an excel addin which is used to perform data analysis & create data models. It was introduced by Microsoft in Excel 2010...