Skip to main content

DAX Language - Data Analysis Expression



The DAX language was created specifically for the handling of data models, through the use of formulas and expressions. DAX is used in several Microsoft Products such as Microsoft Power BI, Microsoft Analysis Services and Microsoft Power Pivot for Excel.

Below are the types of Dax functions 

1. Aggregate 
2. Date and time
3. Filter
4. Financial 
5. Information 
6. Logical
7. Maty and trig
8. Other
9. Parent and child
10. Relationship Management 
11. Statistical 
12. Table manipulation 
13. Text
14. Time intelligence 

From the above list of functions 3 types of functions are basic and commonly used, those are Aggregate , Logical and Date and time.


Other important entities which are used with the above function are as follows 

1. Operators 
Example -  ( ), + , Not, &, =, < >, ||

2. Statements 
Define , Evaluate,  Order by, Return, Var

3. Data Types
Binary, boolean,  Currency,  date time, decimal, integer, String , Variant.


In crude language DAX is an advanced version of Excel formulas.
DAX contains similar formulas as in Excel. With dax functions you can filter the data according to specific conditions as we do it with slicers and filter we do in excel.
In DAX data is stored in tabular format. 
There are two Primary calculation you can create using DAX 
1. Calculated column
It means formulas written in columns 

2. Measures 
Formulas written in the area below table.
A formula used to manipulate data is called a measures. 


Advice - I have worked in many automation projects and used Dax functions for past 3 years. While working don't limit your thought process to what you know think what you want i.e the final result. If you don't know the formula but you have a basic idea of the end result then you are on track just search on google and you will get the answers.



Labels:

Comments

Post a Comment

Popular posts from this blog

Data Model an easy substitute for Vlookup

  you have a data set with product, date, customer, and sales information. The IT department forgot to put sector in there. Here is a lookup table that maps customer to sector. Time for a VLOOKUP, right? There is no need to do VLOOKUPs to join these data sets if you have Excel 2013 or newer. These versions of Excel have incorporated the Power Pivot engine into the core Excel. (You could also do this by using the Power Pivot add-in for Excel 2010, but there are a few extra steps.) In both the original data set and the lookup table, use Home, Format as Table. On the Table Tools tab, rename the table from Table1 to something meaningful. I’ve used Data and Sectors. Select one cell in the data table. Choose Insert, Pivot Table. Starting in Excel 2013, there is an extra box, Add This Data to the Data Model, that you should select before clicking OK. The Pivot Table Fields list appears, with the fields from the Data table. Choose Revenue. Because you are using the Data Model, a new line a...
Post a Comment
Read more

Update All Sheets at same time in a Excel Workbook

Say you have to urgently submit a file with many sheets. For Example put a Header or write a same  data for all sheets. I will show you an amazingly powerful tool called Group mode. Say that you have 12 worksheets that are mostly identical. You need to add totals to all 12 worksheets. To enter Group mode, right-click on any worksheet tab and choose Select All Sheets. The name of the workbook in the title bar now indicates that you are in Group mode. Anything you do to the January worksheet will now happen to all the sheets in the workbook. Why is this dangerous? If you get distracted and forget that you are in Group mode, you might start entering January data and overwriting data on the 11 other worksheets! When you are done adding totals, don’t forget to right-click a sheet tab and choose Ungroup Sheets.
Post a Comment
Read more

Improve your Excel Productivity with these Shortcuts and formulas

I have given below 45 tips and tricks to improve your productivity while working in Excel. Useful Keyboard Shortcuts 1.  To format any selected object , press ctrl+1 2.  To insert current date , press ctrl+; 3.  To insert current time , press ctrl+shift+; 4.  To repeat last action , press F4 5.  To edit a cell comment , press shift + F2 6.  To autosum selected cells , press alt + = 7.  To see the suggest drop-down in a cell , press alt + down arrow 8.  To enter multiple lines in a cell , press alt+enter 9.  To insert a new sheet , press shift + F11 10.  To edit active cell , press F2 (places cursor in the end) 11.  To hide current row , press ctrl+9 12.  To hide current column , press ctrl+0 13.  To unhide rows in selected range , press ctrl+shift+9 14.  To unhide columns in selected range , press ctrl+shift+0 15.  To recalculate formulas , press F9 16.  To select data in current region , press ctrl+shift+8 ...
Post a Comment
Read more