Categories

Microsoft Power BI DAX from Scratch

Description

Should you’re any person dealing with reporting, with the help of DAX capabilities you’ll be capable of unlock the superior power of reporting in Energy BI. These capabilities will present assist to get larger info insights.

DAX or Info Analysis Expression is a library of capabilities and operators, using which you’ll be capable of create formulation and expressions. This may present assist to with creating extremely efficient formulation to ease your info analysis and reporting course of.

This course is designed in a Downside Assertion – Decision format the place we start with the difficulty to which a solution is sought with the help of DAX capabilities the place each a part of the expression is clearly outlined in easy-to-understand phrases,

What’s in retailer for you?

On this course, you’ll

1. Understand the thought of DAX and create calculate column, measure, tables, and quick measures

2. From the exhaustive itemizing of DAX capabilities, we are going to most likely be making an attempt into basically probably the most frequently used capabilities from the family of

  • Date and Time function – WEEKDAY,  EDATE, EOMONTH,  DATEDIFF, TODAY, NOW

  • Textual content material function – FORMAT, COMBINEVALUES, LEFT, RIGHT, FIND, UPPER, LOWER, UNICHAR, REPT

  • Logical function – IF, Nested IF, AND, OR, SWITCH

  • Relationship function – RELATED, CROSSFILTER, RELATEDTABLE

  • X-function – SUMX, RANKX

  • Filter function – CALCULATE, ALL, EARLIER, FILTER, LOOKUPVALUE

  • Statistical function – DISTINCTCOUNT

  • Time intelligence function- DATESYTD, DATEADD, SAMEPERIODLASTYEAR

  • Information function- CONTAINS

  • Desk manipulation function- SUMMARIZECOLUMNS

Join us on telegram for Course Updates
Views:
3
Article Categories:
Udemy Free Courses

Leave a Reply

Your email address will not be published. Required fields are marked *