@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
Great videos and this video is one of many fine videos. I've been working with PowerBI for 5 years and i like to return to the basics from time to time because sometimes a refresher is always a good way to maintain your level of understanding the basics.
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.
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.
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.
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
@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..
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()
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 .
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?
Great videos and this video is one of many fine videos.
I've been working with PowerBI for 5 years and i like to return to the basics from time to time because sometimes a refresher is always a good way to maintain your level of understanding the basics.
Thanks!
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 :)
U r one of those few who make best DAX videos imo
Omgggg, you explain soooo wonderfully well! Thanks for putting the videos together. They are so helpful…
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.
ممكن اعرف ازاى اعمل تجميع لعدد بناء على شرطين وتاريخ 13:56
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 "explainer" - thanks !
Very nice video summing up a lot of the head scratcher gotchas in DAX. Thanks!
Thank you for this explanation! Your explanations are simple and easy to understand!
Awesome Chandeep!! ❤❤
I think, youtube should provide a salute button for such amazing video's.
You have strong didactic abilities. Keep it up!
Download the file ⬇ - goodly.co.in/7-dax-golden-rules
Incorrect Totals in Power BI - th-cam.com/video/yw0QHu9V4UQ/w-d-xo.htmlsi=DOt9R5lOJgAsJIVP
Really fantastic, and helpful
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
good stuff Chandeep!
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..
Simply, it does not get better than that ❤
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()
Excellent tips.
Chandeep thanks man...
These seven steps help to develop logic for writing any kind of Dax...
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 .
Please put a power bi data modeling in step by step Process
thank you
why you dont make a complete power bi tutorial with all these examples which you have in short videos on your channel?
Awesome
Probably can write visual calcs soon though ;)
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:)