7 Simple Concepts of Writing Powerful DAX 🔥

[@imdaboss6918]

10:05 Not true. Calculated columns are compressed by the Vertipaq engine as well

[@GoodlyChandeep]

Really? I was aware they are not. I'll check again. Thanks a ton

[@DrAlexisOlson]

​ @GoodlyChandeep There's some subtlety here. If a calculated column has a one-to-one correspondence with an existing column, then I think it gets the same compression automatically but the compression isn't necessarily optimized in general since it isn't part of the compression optimization that happens when the data model is loaded. That's my understanding anyway. It's possible things have changed too.

[@mohamedchafikainas8846]

Vertipaq is used for in-memory storage and Directquery is used for direct connections to external sources ; both create datacaches and send them to the formula engine for DAX query evaluation. Data is stored in individual columns that can be accessed quickly , but queries that call multiple columns may require more complex logic to produce datacache. Data can b compressed using Value, Hash (Dictionary), or Run Length encoding (RLE) , based on cardinality, repeat values, row count and data type

[@priyeshsanghvi8424]

@@DrAlexisOlson ....I thought the compression depended on the number of distinct values only in the column, is it not so?

[@samanthapikus3178]

Oh my Goodness!!! You explain so wonderfully especially for people who come from the Excel point of view. I struggled with the concept of when to Use an Iterator and when not to use one. Thank you. You're also engaging to watch.

[@GoodlyChandeep]

Thanks Samantha :)

[@peterrender4716]

Excellent Video clearly explaining several of the key concepts in DAX that I have been using in expressions after watching other trainig videos but the videos have not explained the fundamental principles and therefore I have not understood the basis on which various functions work. Thanks Chandeep.

Omgggg, you explain soooo wonderfully well! Thanks for putting the videos together. They are so helpful…

[@JCC.M.]

Thank you for this explanation! Your explanations are simple and easy to understand!

[@bradj229]

Very nice video summing up a lot of the head scratcher gotchas in DAX. Thanks!

[@danishnawaz3651]

Sir, plz make video for below. If 1 table has 9 column, 2 table has 10 and 3 table has 8 . Then how can we make equal all column for all table.. like we want to insert dummy column for missing column in tables and make equal like 10 column for each table.

[@manojchavan6917]

I think, youtube should provide a salute button for such amazing video's.

[@josecarlosconejo5724]

You have strong didactic abilities. Keep it up!

[@surajchavan6447]

Awesome Chandeep!! ❤❤

[@zahir585]

Simply, it does not get better than that ❤

[@sandeepbarge4699]

When is it mandatory to use RELATED() and RELATEDTABLE() functions and when they are not required to access other table's column?

[@jishnusachidanandan5866]

when you need to get data from one side of relationship need to use related(). And if need to get from many side, where we have multiple values relates as in table, use relatedtable()

[@paravej]

Chandeep thanks man... These seven steps help to develop logic for writing any kind of Dax...

[@vishnupp5944]

Really fantastic, and helpful

[@mohamedyoussef8367]

ممكن اعرف ازاى اعمل تجميع لعدد بناء على شرطين وتاريخ ‏‪13:56‬‏

[@Super-Sal]

why you dont make a complete power bi tutorial with all these examples which you have in short videos on your channel?

[@cherianiype]

good stuff Chandeep!

[@FaisalAli-km3xw]

Sir Please make a video on data cleaning. Please take the data from Kaggle and work on it. Please make brief video on data cleaning

[@govindkumardasamantarao562]

Please make a video as to when to use Filter Function in Calculate Function. i.e when to use simple filters without Filter Function and when to use Filter Function in Calculate function. There is always a confusion on this

[@williamarthur4801]

Regarding Column / Measure, does anyone know why a COLUMN will work with ALLEXCEPT and not ALL ( ) & VALUES ( ) , they both work in a measure; CALCULATE( COUNTA( Table1[Item]), ALL( Table1),VALUES(Table1[Item]) ) gives overall count? CALCULATE( COUNTA(Table1[Item]), ALLEXCEPT( Table1,Table1[Item]) ) , sees row .

[@GoodlyChandeep]

Download the file ⬇ - goodly.co.in/7-dax-golden-rules Incorrect Totals in Power BI - kzbin.info/www/bejne/r6iTgnurbrtni7Msi=DOt9R5lOJgAsJIVP

[@emilmubarakshin49]

Probably can write visual calcs soon though ;)

[@rajnishkumarchoudhary7520]

Can you make a detailed video on pbi self service

[@evelic]

Excellent tips.

[@POWER_OF_MOTIVATION_6393]

Please put a power bi data modeling in step by step Process

[@pbihari0214]

thank you

[@NikitaShilyaev]

8:35 And in Jul 2024 we now have it 🙃

[@vidyashreeips]

@GoodlyChandeep Hi I need help. i am developing a dashboard for Collections efficiency. i facing challenge , i want a table to display the aging of currant month and last few months and this should be dynamic based on today's date. if today is 16 oct then column name should be October, if today is 15th oct then column name should be Sep 2023. i created a measure and new parameter for changing column names dynamically. but when i am using the filter options like show data for last 4 months, the table names are not changing. and new parameter created is not interactive with the slicer.. please help me to solve this..

[@gkirankumarskht]

Awesome

[@Wzxxx]

Rule 8: You will never ever write correct DAX in first attemto. Resetve couple hrs even for simple math concepts:)

[@jerrydellasala7643]

The download Zip file doesn't have the Excel data file! It has Book1.xlsx which doesn't fit the Power BI data needed which is supposed to be D:\Courses\Power BI - DAX Course\Online Data.xlsx 😠

[@jkumar8590]

High speed lecture. Not able to follow

[@AA-kq8on]

Hello goodly, Plz, kann you sind me your Email i want to ask about M-query kurs Thank you in advance

[@GoodlyChandeep]

[e-mail]

[@darins]

I struggled with Rule #5 for a long time when I was starting out. There was very clear guidance around using measures instead of calculated columns, but I wasn't sure when to use a calculated column. For me, I only seem to need calculated columns when I want to slice or filter by the values in that column.