Microsoft Power BI DAX from Scratch
Table of Contents
Description
If you’re 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 provide help to get higher information insights.
DAX or Information Evaluation Expression is a library of capabilities and operators, utilizing which you’ll be able to create formulation and expressions. This can provide help to with creating highly effective formulation to ease your information evaluation and reporting course of.
This course is designed in a Drawback Assertion – Resolution 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 create calculate column, measure, tables, and fast measures
2. From the exhaustive listing of DAX capabilities, we will probably be trying into essentially the most regularly 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
-
Data function- CONTAINS
-
Desk manipulation function- SUMMARIZECOLUMNS
![[100% OFF] Crash Course on Civil Engineering and AutoCAD: Part 5](https://i2.wp.com/getintocourse.com/wp-content/uploads/2021/08/100-OFF-Crash-Course-on-Civil-Engineering-and-AutoCAD-Part.jpg?resize=390%2C220&ssl=1)
