Description
In case you are somebody coping with reporting, with the assistance of DAX capabilities you’ll be able to unlock the superior energy of reporting in Power BI. These capabilities will enable you get higher information insights.
DAX or Knowledge Evaluation Expression is a library of capabilities and operators, utilizing which you’ll create formulation and expressions. It will enable you with creating highly effective formulation to ease your information evaluation and reporting course of.
This course is designed in a Downside Assertion – Answer format the place we begin with the issue to which an answer is sought with the assistance of DAX capabilities the place every part of the expression is clearly defined in easy-to-understand phrases,
What’s in retailer for you?
On this course, you’ll
1. Perceive the idea of DAX and learn how to create calculate column, measure, tables, and fast measures
2. From the exhaustive checklist of DAX capabilities, we shall be trying into essentially the most continuously used capabilities from the household of
-
Date and Time operate – WEEKDAY, EDATE, EOMONTH, DATEDIFF, TODAY, NOW
-
Textual content operate – FORMAT, COMBINEVALUES, LEFT, RIGHT, FIND, UPPER, LOWER, UNICHAR, REPT
-
Logical operate – IF, Nested IF, AND, OR, SWITCH
-
Relationship operate – RELATED, CROSSFILTER, RELATEDTABLE
-
X-function – SUMX, RANKX
-
Filter operate – CALCULATE, ALL, EARLIER, FILTER, LOOKUPVALUE
-
Statistical operate – DISTINCTCOUNT
-
Time intelligence function- DATESYTD, DATEADD, SAMEPERIODLASTYEAR
-
Info function- CONTAINS
-
Desk manipulation function- SUMMARIZECOLUMNS