@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.
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
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.
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.
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.
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()
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
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 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..
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 😠
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.
10:05 Not true. Calculated columns are compressed by the Vertipaq engine as well
Really? I was aware they are not. I'll check again. Thanks a ton
@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.
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
@@DrAlexisOlson ....I thought the compression depended on the number of distinct values only in the column, is it not so?
Thanks!
U r one of those few who make best DAX videos imo
Excellent "explainer" - thanks !
Download the file ⬇ - goodly.co.in/7-dax-golden-rules
Incorrect Totals in Power BI - ruclips.net/video/yw0QHu9V4UQ/видео.htmlsi=DOt9R5lOJgAsJIVP
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.
Thanks Samantha :)
ممكن اعرف ازاى اعمل تجميع لعدد بناء على شرطين وتاريخ 13:56
Thank you for this explanation! Your explanations are simple and easy to understand!
Omgggg, you explain soooo wonderfully well! Thanks for putting the videos together. They are so helpful…
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.
Very nice video summing up a lot of the head scratcher gotchas in DAX. Thanks!
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.
Awesome Chandeep!! ❤❤
Really fantastic, and helpful
You have strong didactic abilities. Keep it up!
good stuff Chandeep!
When is it mandatory to use RELATED() and RELATEDTABLE() functions and when they are not required to access other table's column?
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()
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
Simply, it does not get better than that ❤
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 .
I think, youtube should provide a salute button for such amazing video's.
Can you make a detailed video on pbi self service
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
@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..
Chandeep thanks man...
These seven steps help to develop logic for writing any kind of Dax...
Excellent tips.
Please put a power bi data modeling in step by step Process
Probably can write visual calcs soon though ;)
why you dont make a complete power bi tutorial with all these examples which you have in short videos on your channel?
thank you
Awesome
8:35 And in Jul 2024 we now have it 🙃
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 😠
High speed lecture. Not able to follow
Hello goodly,
Plz, kann you sind me your Email i want to ask about M-query kurs
Thank you in advance
Goodly.wordpress@gmail.com
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.
Rule 8: You will never ever write correct DAX in first attemto. Resetve couple hrs even for simple math concepts:)