Skip to content

KanchanCS/power_bi_project

Repository files navigation

<<<<<<< HEAD

power_bi_dashboard

=======

power_bi_dashboard 👍

🔍 In your data analyst journey, while working on reports, you have to came across with these essential DAX functions.

➡️ SUM () : Adds all the numbers in a column.

➡️ SUMX () : Returns the sum of an expression evaluated for each row in a table.

➡️ AVERAGE () : Returns the average (arithmetic mean) of all the numbers in a column.

➡️ MAX () : Returns the largest value in a column.

➡️ MIN () : Returns the smallest value in a column.

➡️ DISTINCTCOUNT() : The number of distinct values in a Column.

➡️ CALCULATE () : Evaluates an expression in a context modified by filters.

➡️ Date(): Returns the specified date in date time format.

➡️ TOTALYTD () : Evaluates the year-to-date value of the expression in the current context

➡️ COUNT(): Counts the number of rows in the specified column that contain non-blank values

Specifically, I assembled some of my favorite playlist dedicated to DAX only that I have followed which you can explore for better understanding.

2cbae9bdb4eae86e11260a08bff25c89ee02eb6b