can you please continue to upload more Python tutorials🙏😊. you are the best teacher. Can please you add as part 2 the continuity of "Python for Data Analysis: The Beginner’s Ultimate Guide" video.🙏
I am using a free software called Zoomit. You can download it from Microsoft Windows Sysinternals webpage - learn.microsoft.com/en-us/sysinternals/downloads/zoomit
Hi Chandoo, I desperately need your help. I have a column of data in a pivot table and I'd like to standardize this column values, how can I create a DAX measure to do that? I tried the formula: Standardized = (Table[Value] - STDEVX.P(Table, Table[Value]))/AVERAGEX(Table, Table[Value]) but something is wrong!
I suggest doing this operation in Power Query or SQL for performance reasons. But if you prefer doing it in DAX, here is the code: Column = ('Table'[Column1]- STDEVX.P(ALL('Table'[Column1]),'Table'[Column1])) / AVERAGEX(ALL('Table'[Column1]), 'Table'[Column1])
@@chandoo_ Thanks for the reply. Unfortunately, I get this error: "This formula is invalid or incomplete: 'Calculation error in measure 'Combined'[2188f049-5373-4f9c-b2cc-f663cb20ba04]: A single value for column 'المتوسط' in table 'Combined' cannot be determined. This can happen when a measure formula refers to a column that contains many values without specifying an aggregation such as min, max, count, or sum to get a single result". Perhaps, when you have time, can you make a short video showing the PowerQuery method for calculating z-score for a column of values? I'd love to learn that too. Meanwhile I'll try to fix the DAX somehow.
@@chandoo_ Thanks for your reply Chandoo. I tried the DAX formula but I get the kind of errors indicating that multiple values where supplied where a single value was expected. I'd like to learn the PowerQuery method as well. Thanks!
I think you need to learn DAX & Power Query properly. You seem to jumping in the middle. Start with fundamentals and take it slow. Start here: 1) Getting started with Power Query - th-cam.com/video/MMdcczmULrU/w-d-xo.html 2) Getting started with DAX - th-cam.com/video/lD7TvkoQ6rY/w-d-xo.html I have a full step-by-step course that gives you structured learning. Check it here - chandoo.org/wp/power-bi-course/
can you please continue to upload more Python tutorials🙏😊. you are the best teacher. Can please you add as part 2 the continuity of "Python for Data Analysis: The Beginner’s Ultimate Guide" video.🙏
hi chandoo, phenomenal work dude, you are a born teacher, waiting for your next video
Please continue to upload #Python tutorials. A continuous series would be great! 💚
Wowww such an awesome video ,i can't wait for the next one .hope its soon ,litteraly excited ❤🎉
Thank you Chandoo for sharing python tutorial
Can you please start videos on EDA
Sir waiting for the next video on python plots
Chandoo, how do you draw lines while explaining. Pls tell me . If its a software or some settings on window
I am using a free software called Zoomit. You can download it from Microsoft Windows Sysinternals webpage - learn.microsoft.com/en-us/sysinternals/downloads/zoomit
@chandoo_ thank you ji
Hi sir ,can u make a video about how to connect tables in powerbi that has no common key.
Waiting for the next video. 21:54
upload video abount numpy pandas and matplotlib
Hi Chandoo, I desperately need your help. I have a column of data in a pivot table and I'd like to standardize this column values, how can I create a DAX measure to do that? I tried the formula: Standardized = (Table[Value] - STDEVX.P(Table, Table[Value]))/AVERAGEX(Table, Table[Value]) but something is wrong!
I suggest doing this operation in Power Query or SQL for performance reasons. But if you prefer doing it in DAX, here is the code:
Column = ('Table'[Column1]- STDEVX.P(ALL('Table'[Column1]),'Table'[Column1])) / AVERAGEX(ALL('Table'[Column1]), 'Table'[Column1])
@@chandoo_ Thanks for the reply. Unfortunately, I get this error: "This formula is invalid or incomplete: 'Calculation error in measure 'Combined'[2188f049-5373-4f9c-b2cc-f663cb20ba04]: A single value for column 'المتوسط' in table 'Combined' cannot be determined. This can happen when a measure formula refers to a column that contains many values without specifying an aggregation such as min, max, count, or sum to get a single result". Perhaps, when you have time, can you make a short video showing the PowerQuery method for calculating z-score for a column of values? I'd love to learn that too. Meanwhile I'll try to fix the DAX somehow.
@@chandoo_ Thanks for your reply Chandoo. I tried the DAX formula but I get the kind of errors indicating that multiple values where supplied where a single value was expected. I'd like to learn the PowerQuery method as well. Thanks!
I think you need to learn DAX & Power Query properly. You seem to jumping in the middle. Start with fundamentals and take it slow. Start here:
1) Getting started with Power Query - th-cam.com/video/MMdcczmULrU/w-d-xo.html
2) Getting started with DAX - th-cam.com/video/lD7TvkoQ6rY/w-d-xo.html
I have a full step-by-step course that gives you structured learning. Check it here - chandoo.org/wp/power-bi-course/
Sir please making latest excel mutual fund tracker in one video sir. Your website template now not working sir