Can you help ow to learn dax

[Poojajunnu]

Can you help ow to learn dax

[v-saisrao-msft]

Hi @Poojajunnu,

Thank you @rohit1991 @FBergamaschi, for your insights.

You can also refer to the below official Microsoft resources to learn DAX:

DAX Documentation & Training: Data Analysis Expressions (DAX) Reference - DAX | Microsoft Learn

Dashboard in a Day (DIAD): Dashboard in a Day Power BI Training | Microsoft Power BI

Hope this helps

Thank you.

[rohit1991]

Hi @Poojajunnu 

Start with these, then practice a little every day:

Books (start with one)

• Supercharge Power BI: Matt Allington

• The Definitive Guide to DAX: Russo & Ferrari: https://www.sqlbi.com/books/the-definitive-guide-to-dax/

Free learning (Microsoft Learn)

• DAX overview: https://learn.microsoft.com/en-us/dax/dax-overview

• DAX basics quickstart: https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-quickstart-learn-dax-basics

• Time intelligence: https://learn.microsoft.com/en-us/dax/time-intelligence-functions-dax

YouTube

• Guy in a Cube : https://www.youtube.com/c/GuyinaCube

• SQLBI : https://www.youtube.com/c/SQLBI

What to actually focus on

• Row context vs filter context

• CALCULATE() + context transition

• Iterators (SUMX, AVERAGEX, …)

Tip: Don’t try to memorize every function. Get comfortable with context, then read the function docs as needed and apply.

[FBergamaschi]

Hi @Poojajunnu,

step 1 is books or video courses (electronic version is preferred)

books

- Supercharge Power BI (introduction to DAX)

- The Definitive Guide to DAX (high-level DAX)

video courses

- SQLBI.com (Introdction to DAX - free course - and then Mastering DAX)

step 2 apply it every day to your job via Power BI or Power Pivot

Avoid quick courses on the web, stay n trusted and renowed professional, understand what you are doing in DXA even for very simple initial steps

If this helped, please consider giving kudos and mark as a solution

@me in replies or I'll lose your thread

Want to check your DAX skills? Answer my biweekly DAX challenges on the kubisco Linkedin page

Consider voting this Power BI idea

Francesco Bergamaschi

MBA, M.Eng, M.Econ, Professor of BI

[Poojajunnu]

So there is one more reuirement, i need to calculate day wise cummulative count for active chatgpt users, i need a measure