waiting for the part-3 in HR Dashboard series where you can teach Navigation and developing 3rd screen. If already available please comment the link here
Thank you for the great work you have put in. Waiting for the part 3 of this series for the navigation from one screen to another per se . It is highly expected. Thank you
@Data with Decision Thank you for the great work you have put in. Waiting for the part 3 of this series for the navigation from one screen to another per se . It is highly expected. Thank you
Hi, thank you for sharing...Please, at 12:13 on the Excel worksheet, what you had after some minutes is quite different from the main one... How did you achieve that?
Thank you, Sir. The part about finding duplicates could be more transparent. In fact, in my understanding, duplicate means promotion=retrenchment=1. As we have the same employee names in the promotion table and retrenchment table, to find a duplicate, you should sort by name the two tables and find where promotion=retrenchment=1.
Thank you very much for the Tutorial. My question is that , in my PowerBI table, I noticed that the people who are not due for promotion still showed up but with value "0" but in your own they were not there
HI, great video and explanation. just the excel for promotion and retrenchment people excel lists, the source are different from what you have. can you upload an updated version. Thank you very much!
So, if you're struggling with High Rated & Low Rated Here's the help. First create a new measure and use this formula. High Rated Count = COUNTROWS(FILTER('HR Analytics Data', 'HR Analytics Data'[Performace Rating] = "High Rating")) & Low Rated Count = COUNTROWS(FILTER('HR Analytics Data', 'HR Analytics Data'[Performace Rating] = "Low Rating")) After creating these two measures create 2 more new measures and follow this. % High Rated = DIVIDE([High Rated Count], COUNTROWS('HR Analytics Data'), 0.01) & % Low Rated = DIVIDE([Low Rated Count], COUNTROWS('HR Analytics Data'), 0.01) You're welcome, happy learning :)
Thank you for this video. i think there is a mistake and it's me misunderstanding. you want to look for employees that are going to be promoted and retrenched at the same time. in the sheet that you have the employee's lists isn't the same ( for promotion you have only the list of employees to be promoted), for the retrenched you have the list of all employees ( 0 for employee to be retranched and 1 for employee that are not going to), it means that the order of employees for both list isn't the same. So, in order the see if an employee belongs to both the promoted list and retrenched list we have to test if he is going to be retrenched = 1 and then if we find him name in the promoted list then he belongs to the list.
Part 2 is again the amazing one❤🎉thank you so much sir for this wonderful section. I tried to add the navigation button but could craft cool navigation buttons like u did i mean the style of ur navg buttons.. I'll be glad if u let us kw how u did that.
Hello, thanks a lot for these videos, they have helped me a lot :) I just have a question: when you created the list of "will be retrenched at 8:40 minute, as you can see there are ones and zeros, ones for employees who are gonna be retrenched and zeros for those who keep on service, so that means when you downloaded this list to excel actually you took all employees, could be there a mistake with that procedure? besides, when you try to find duplicates in excel you use the if function, wouldn´t be more appropriate to find them using the vlooup function?, because in the way you are using the if function just compares cell by cell instead all the range that we need look for. Thanks so much!
I'm so thankfull to u that u mentioned this oversight by sir at 8:41 .. Since no body was mentioning it I thought may be I'm thinking it in wrong way. 😂 After taking only the values which are 1 from both the. Csv files, I got 4 names? Is that right?
To get a more accurate amount of duplicates, this is the formula - =IF(COUNTIF($A$2:$A$73, B2)>0, "Y", "N") in column c (assuming Promotion is A & Retrenchment is B). Then after this, on column D, insert this formula, =IF(C2="Y",B2,"").
very nice work, I've follow you in the part1 and i make-it very easy....thank u. I'll begin this second part and i hope to finalize-it as the 1 part.....good job.
at 12:17 we can clearly see entry #5 Abram Q Keffer has no corresponding duplicate value, hence "N" . But suddenly at 12:24 it changes to "Y' for duplicate value. Can you explain how did this magic happen?
I used IF and AND functions to find the answers on Due for Promotion and Will be retrenched columns. Cause think about it, if you have employees due for promotion and will be retrenched set to 1, it makes no sense, so something should be done about those employees, if you have employees due for promotion set to 1 and will be retrenched set to 0, then those the ones that will be promoted. That's basically the logic I used.
Thank you so much for the amazing work. However, cannot see the last bit of putting all the icons together part, would you post that in some near future? Many thanks
You find the solutions in this project. Watch this Full Power BI Course (Power BI Desktop & DAX): ua-cam.com/play/PLwIcJx1aSL1QP_6xAGDK6EViMGq9ysrc2.html
Hi, thank you for the video. I have a doubt, for adding total employees in each department, I am getting the total number of employees designated for each department. For eg. if the total employees are 200, I am getting 200 in each department. What should I do about it?
This is one of the best tutorial i have seen. You had very good and important examples needed. I shared as well.I really appreciate the effort. I watched like watching a movie. At times looking at subs. , 😀Thanks a lot ❤
Thank you for another great session. In your subsequent uploads, could you please include a situation where there isn't a 100% match when merging queries and how to deal with it !
You can take our full power bi course and learn everything you need to learn: www.udemy.com/course/power-bi-data-analytics-course-and-dashboards-creation-2022/
First, let me commend you for your attention to details, it’s 100. In this video, you didn’t show how you created the home, action and detail slicer and how it slices through the dashboard. Give me any of your video where it demonstrated. I have been trying it but am mixing things up.
I got stuck there too. I think he just manually changed some of the names in the first column, so that there would be some duplicates, so I did the same
@@luquest_9438 i realized that my duplicates were totally different from that of the instructor... he had duplicates whose name began with A... mine were at the bottom
I Think that what you have done in Excel is not a good practice to find the duplicate , that may imply error , you have find only 6 people in duplicate but in fact there are 54
If you missed any part please watch this: Watch this Full Power BI Course (Power BI Desktop & DAX): ua-cam.com/play/PLwIcJx1aSL1QP_6xAGDK6EViMGq9ysrc2.html
there is a problems with the employees that are due for promotion and will be retrenched , Abram Q Keffer Alanna L Tyrell Akiko S Godby Agnes Blow those employees are neither due for promotions nor will be retrenched can anyone explain ??
Will do something similar to this on our new channel. You can subscribe to our new Data Analytics channel:ua-cam.com/video/4qx-SJc1Xsk/v-deo.htmlsi=7Y1SpDxXXz9Qpdwj
If one persons name appeared in the two.... Is best for the management to decide whats best for the employee. Remember, retrenchment is not a healthy moment in an organization. It can comes at a point when you got due for promotion.
0. If for someone formula from 12:10 doesn't work check this: =IF(A3=B3;"1"; "0") or if you have other excel language translate ,,IF" to your native word meaning English "if". For Polish it is 'jeżeli" so in polish lang. Excel formula should be: ,, =JEŻELI(A2=B2;"1"; "0") " ,, =IF(A2=B2;"1"; "0") " will DO NOT work
It’s very clear the Tutor did manually type some names in the Remove duplicates part because if we Pause the video at 12.51 and look over to the Promotion Column First Value= “Adelaide L Harrop “ and then match it with Employee name Retrenchment column value in cell 10 we see the same name Adelaide L Harrop and to which the find duplicates column says “N”. Quite funny.
@@datalab365 Don't think people watching your videos to learn are fools... It's very much evident that the video was edited and those values were manually typed.. You can go back on your video, pause it at 12.51 and refer the 2 column and see for yourself the Duplicate name in column 1 and column 2 being same , just the cell no.s are different which obviously IF function will never be able to give back the result as duplicate as it will only refer values in cells of same row... And mind you there were 54 duplicate values( when the names of both column are put in one single column and then remove duplicate option is utilised. Unfortunately UA-cam doesn't allow screenshot to be uploaded otherwise i would have given a evidence of how where you are wrong and deliberately not accepting it...
@@datalab365 The first part of your video on this Report was no doubt Superb . But in this part almost all people who have commented did face issues in Excel Duplicate part which can only be possible if some editing has been done in the sheet but obviously not made public.. I did read a few comments where the 1. end result was different to what you got and so on.....
@@datalab365 So i think you used the If(And) function to get the names. But it only returns the names as Duplicate if the name in column 1 ( Row 2) is same as name in Column 2(Row 2). On contrary it gives the result as Not Duplicate if the same in Column 1(Row 2) is present in Column 2 (Row 3). On the final note the function used if( and) function gives a list of 4 employees, names of which are totally different to what you got obviously through some manually typed names in the list that's why the video is obviously edited at that stage .
@@jayashree4745 check the datatype of your performance rating to make sure is a text. Add filter function after [total emo] Calculate([total emo], Filter(hr analytics data[ performance rating ] ="High rating" )
Hello sir , can you just clarify in this video how % high rated and % low rated has been created Because when i am trying to show this visual it shows : MdxScript(Model) (19, 57) Calculation error in measure 'All Measures'[High Rated]: DAX comparison operations do not support comparing values of type Integer with values of type Text. Consider using the VALUE or FORMAT function to convert one of the values. Please Tell me.
Create measures for high and low rated first then branch out to calculate the percentages. That is you will have to divide either high rating or low rating by the total employees using the divide function. Hope this is clear, let me know if I can assist further.
Watch part-1 here: ua-cam.com/video/0BKlUySopU4/v-deo.html
waiting for the part-3 in HR Dashboard series where you can teach Navigation and developing 3rd screen. If already available please comment the link here
Thank you for the great work you have put in. Waiting for the part 3 of this series for the navigation from one screen to another per se . It is highly expected. Thank you
@Data with Decision Thank you for the great work you have put in. Waiting for the part 3 of this series for the navigation from one screen to another per se . It is highly expected. Thank you
Just make the default color for the button corresponding to the page mentioned in the button@@KarthikArji
That's amazing sir, but where is the tutorial to make the navigation? I 've ever seen it yet sir in this video
ua-cam.com/video/cFZtUzABOa8/v-deo.html
OMG, totally fell in love with the vidoes. I learned so much from these videos. Thanks for providing such an insighful tutorials!
🙏
Hi, thank you for sharing...Please, at 12:13 on the Excel worksheet, what you had after some minutes is quite different from the main one...
How did you achieve that?
Thank you, Sir. The part about finding duplicates could be more transparent. In fact, in my understanding, duplicate means promotion=retrenchment=1. As we have the same employee names in the promotion table and retrenchment table, to find a duplicate, you should sort by name the two tables and find where promotion=retrenchment=1.
Thanks, Kader. There are many ways to do things in Power BI. Thanks for connecting with Data with Decision.
Thank you very much for the Tutorial. My question is that , in my PowerBI table, I noticed that the people who are not due for promotion still showed up but with value "0" but in your own they were not there
HI, great video and explanation. just the excel for promotion and retrenchment people excel lists, the source are different from what you have. can you upload an updated version. Thank you very much!
So, if you're struggling with High Rated & Low Rated
Here's the help.
First create a new measure and use this formula.
High Rated Count = COUNTROWS(FILTER('HR Analytics Data', 'HR Analytics Data'[Performace Rating] = "High Rating"))
&
Low Rated Count = COUNTROWS(FILTER('HR Analytics Data', 'HR Analytics Data'[Performace Rating] = "Low Rating"))
After creating these two measures create 2 more new measures and follow this.
% High Rated = DIVIDE([High Rated Count], COUNTROWS('HR Analytics Data'), 0.01)
&
% Low Rated = DIVIDE([Low Rated Count], COUNTROWS('HR Analytics Data'), 0.01)
You're welcome, happy learning :)
Thank you
Thank you for this video. i think there is a mistake and it's me misunderstanding.
you want to look for employees that are going to be promoted and retrenched at the same time. in the sheet that you have the employee's lists isn't the same ( for promotion you have only the list of employees to be promoted), for the retrenched you have the list of all employees ( 0 for employee to be retranched and 1 for employee that are not going to), it means that the order of employees for both list isn't the same. So, in order the see if an employee belongs to both the promoted list and retrenched list we have to test if he is going to be retrenched = 1 and then if we find him name in the promoted list then he belongs to the list.
yes and the employee names that he got is not going to be retrenched nor promoted
Part 2 is again the amazing one❤🎉thank you so much sir for this wonderful section. I tried to add the navigation button but could craft cool navigation buttons like u did i mean the style of ur navg buttons.. I'll be glad if u let us kw how u did that.
Thanks so much for this tutorial, it was clear, precise and well detailed. Can you please guide on how the navigation section was created?
ua-cam.com/video/ovQ9czcvotk/v-deo.html
Hello, thanks a lot for these videos, they have helped me a lot :) I just have a question: when you created the list of "will be retrenched at 8:40 minute, as you can see there are ones and zeros, ones for employees who are gonna be retrenched and zeros for those who keep on service, so that means when you downloaded this list to excel actually you took all employees, could be there a mistake with that procedure? besides, when you try to find duplicates in excel you use the if function, wouldn´t be more appropriate to find them using the vlooup function?, because in the way you are using the if function just compares cell by cell instead all the range that we need look for. Thanks so much!
I'm so thankfull to u that u mentioned this oversight by sir at 8:41 .. Since no body was mentioning it I thought may be I'm thinking it in wrong way. 😂
After taking only the values which are 1 from both the. Csv files, I got 4 names? Is that right?
@@nagmafariyal8982 you must have 54 names in duplicate , so 54 people can be promoted an be retrenched at the same time
we coould find the list of employees who are going to be promoted and retrenched by using filter
To get a more accurate amount of duplicates, this is the formula - =IF(COUNTIF($A$2:$A$73, B2)>0, "Y", "N") in column c (assuming Promotion is A & Retrenchment is B). Then after this, on column D, insert this formula, =IF(C2="Y",B2,"").
Hello, do you mean we have more than that number?
thank u, it's so helpful
Thanks a lot brother
@@TaofiqAdeyemo-s3i yes we should have 54 :)
very nice work, I've follow you in the part1 and i make-it very easy....thank u. I'll begin this second part and i hope to finalize-it as the 1 part.....good job.
Thanks 🙏
You are too good to be ignored.Thank you for all you do
Nice having you on the channel
at 12:17 we can clearly see entry #5 Abram Q Keffer has no corresponding duplicate value, hence "N" . But suddenly at 12:24 it changes to "Y' for duplicate value. Can you explain how did this magic happen?
I used IF and AND functions to find the answers on Due for Promotion and Will be retrenched columns. Cause think about it, if you have employees due for promotion and will be retrenched set to 1, it makes no sense, so something should be done about those employees, if you have employees due for promotion set to 1 and will be retrenched set to 0, then those the ones that will be promoted. That's basically the logic I used.
Also leave both column that gives 1 and 0 for cross checking.
@@braulioandre2918plzz explain this
Amazing content I must say but I have a question, how did you link the three sheets together and you were able to navigate through the pages?
Is bookmarking
@@datalab365 Thank you. I will look into that.
📢Hey, I want know how to find Employees that will be getting severnce benefit in power bi itself instead of using excel. Please tell me
Super Boss!👏 i learnt a lot from you..
Respect you from India..🙏
Full respect for you.
Sir, please can you explain how you did the excel part again because what I have isn't the same with yours?
I also have the same issue as well as others and I do not see where any answer has been given.
hello , and thanks for your good présentation , where can i find the part 3 of this presentation ??? marc from france
Thanks for this great work. Please, I need help getting the IF command you input in the command getting the duplicates.
Nice tutorial but where is the navigation button how you make it ???
Will do that in my next upload
Thank you so much for the amazing work. However, cannot see the last bit of putting all the icons together part, would you post that in some near future? Many thanks
You find the solutions in this project. Watch this Full Power BI Course (Power BI Desktop & DAX): ua-cam.com/play/PLwIcJx1aSL1QP_6xAGDK6EViMGq9ysrc2.html
@@datalab365 Thank you so much, so insightful!
Hey can u please mention the video which helped you to put the item together. Mention the video name
How do i calculate the high rating and low rating for the measures
You have done an excellent work, and I have learnt alot, can you post the link for part 3?
Thanks and contiune the good work
Sure
@@datalab365 any hope for the lonk of the part 3?
@@davidenwelumnwa7008 I might, if I don't I would make up for that in another dashboard. Thanks for the engagement.
Just finished it. Really helpful and insightful tutorial. Great job!!
Thank you.
im getting error in performance rating sir
Hi, thank you for the video.
I have a doubt, for adding total employees in each department, I am getting the total number of employees designated for each department. For eg. if the total employees are 200, I am getting 200 in each department. What should I do about it?
Amazing explanation pleas make video about navigation page
I will.
You can subscribe to our new Data Analytics channel:ua-cam.com/video/4qx-SJc1Xsk/v-deo.htmlsi=7Y1SpDxXXz9Qpdw
hello sir , can you just clarify in this video how % high rated and % low rated has been created as in previous 1st video it was not shown.
thankyou
ya just repeat same logic ho jayega
Sir can you help with how to make navigation ?have you made any video for that?
I will make a video for that. Noted. Thanks.
@@datalab365 btw the dashboard is beautiful.its helping beginners like me to make new projects through your videos.Have a great day😁
@@datalab365 Hi, waiting for the part 3 video. Please I request you to create it ASAP.
Very good instruction with nice creativity
Thanks.
thank you so mush can you explain how do you make the navigation please
Can you please watch this video. I will teach it in the remaining parts. ua-cam.com/video/ovQ9czcvotk/v-deo.html
ua-cam.com/video/ovQ9czcvotk/v-deo.html which the video, I will make a video in the series on how to create it
@@datalab365 ok thank you so much for your efforts
@12:21
Why should we look for yes values?
Why have you changed few values by yourself which was not shown in the video?
Sorry !
hi, can you make a tutorial on how you curated the navigator tab?
Sure.
please how did get the duplicates "Y" and "N" first there were all "N" then the video was cutoff ??
Everything is fine sir but what he had done ? What problem he found or what decision he made?
Another great tutorial, looking forward to the next in the series.
Thanks
This is one of the best tutorial i have seen. You had very good and important examples needed. I shared as well.I really appreciate the effort. I watched like watching a movie. At times looking at subs. , 😀Thanks a lot ❤
Thank you
Thank you for another great session. In your subsequent uploads, could you please include a situation where there isn't a 100% match when merging queries and how to deal with it !
Okay, hope you were able to download the practice file?
@@datalab365 I did and followed all your steps bro. On standby for the more amazing stuff from your channel
@@Ayuk1 I agree. The duplicate formula did not work. it was all N. Not sure why.
bro please tell me how to add button
Hello, can you teach me how to format table like this?
You can take our full power bi course and learn everything you need to learn: www.udemy.com/course/power-bi-data-analytics-course-and-dashboards-creation-2022/
Thanks for this. How did you create the navigation panel?
I will soon make a video for it
@@datalab365alright! Thank you. Will be expecting
hi loved the video.
can you share the part 3 as well?
The class ends at part 2.
You can watch this. Improve your Power BI Report/Dashboard: ua-cam.com/play/PLwIcJx1aSL1Soc0ONtg8wGG78QyVM9iEb.html
@@datalab365 I wanted to know more about how you made navigation in this particular template
First, let me commend you for your attention to details, it’s 100. In this video, you didn’t show how you created the home, action and detail slicer and how it slices through the dashboard. Give me any of your video where it demonstrated. I have been trying it but am mixing things up.
Sir my dout is ,How do you to set 12:21 to 12:24 i can't understand it....plz explain me
Thought i was the only one who thought something was amiss there.. I hope he can kindly explain what happened
Even i couldn't follow, the instructor skipped the vedio i guess.
Same here, I found out that there is no duplicate between promotion and retrenchment employees
I got stuck there too. I think he just manually changed some of the names in the first column, so that there would be some duplicates, so I did the same
@@luquest_9438 i realized that my duplicates were totally different from that of the instructor... he had duplicates whose name began with A... mine were at the bottom
Awesome video. Thanks for helping us
🙏
what is mean, the cahrt for employee by over time? yes for what and no for what?
Yes: over time
No: not over time.
Hiii can you please explain how did you make the navigation part please i can’t find it in the video
This will help: ua-cam.com/video/uP3VpcT69Y8/v-deo.html
How can I get d data in csv for practice. It's difficult for me to download the data below
can u show how did u create the navigation as a dot ?
Follow this class: ua-cam.com/video/rBuQmKgL5UE/v-deo.html
I will teach there.
@@datalab365 sure, thank you
Please, How did you do the home? Cuz it"s not shown in the video
Learn from here: Watch this Full Power BI Course (Power BI Desktop & DAX): ua-cam.com/play/PLwIcJx1aSL1QP_6xAGDK6EViMGq9ysrc2.html
Hello @data with descison is there a part 3 of this training? The last video in this playlist states "1 unavailable video is hidden"
No part 3.
I will be uploading Power BI Analytics tutorials soon
@@datalab365 Please confirm the part 3 is out as i can't find it.
not able to find the dataset you have used to create dashboard.
Is on a drive 🔗 link in the comment section
Hello, anyone to help please , at 8:40 I am getting similar Employee names in both tables -due to promotion and Retrenchment. @Data with Decision
Thanks
I Think that what you have done in Excel is not a good practice to find the duplicate , that may imply error , you have find only 6 people in duplicate but in fact there are 54
😭
You have explained so well.. I gone through Part1 and 2. Can I have part 3 video link please..
Is just 2 parts.
@@datalab365 eagerly waiting for part 3. Bookmarks and other stuff is not covered in part 2, hope you will release the part 3 soon.
how you did navigation, i can't find any video. can you share me link or tell me
Same here please, I would appreciate
This will help ua-cam.com/video/A92tlBccwMs/v-deo.html
Thank you
you are welcome Ravi
where is part 3 please put link in comment ..its totally incomplete dashboard..there is no navigation part
If you missed any part please watch this: Watch this Full Power BI Course (Power BI Desktop & DAX): ua-cam.com/play/PLwIcJx1aSL1QP_6xAGDK6EViMGq9ysrc2.html
there is a problems with the employees that are due for promotion and will be retrenched ,
Abram Q Keffer
Alanna L Tyrell
Akiko S Godby
Agnes Blow those employees are neither due for promotions nor will be retrenched
can anyone explain ??
Will do something similar to this on our new channel.
You can subscribe to our new Data Analytics channel:ua-cam.com/video/4qx-SJc1Xsk/v-deo.htmlsi=7Y1SpDxXXz9Qpdwj
do you have the video explaning page navigation?
Kindly check out our other power bi videos.
@@datalab365 Which one to be specific please? That navigation of this HR series is the concluding part of this tutorial. Thank you
After this how to save in to excel
You can do that in power bi service
Please can anyone help with the column name used from the HR Analytics Data to calculate the High or Low Rated in the new measure.
Performace rating
Thnx your sharing documents
Thanks
Part 3 bro?
Excel part is confusing. We have the same names in promotion and retrenchment.
If one persons name appeared in the two.... Is best for the management to decide whats best for the employee.
Remember, retrenchment is not a healthy moment in an organization.
It can comes at a point when you got due for promotion.
waiting for final part
A new tutorial is coming up for that.
0. If for someone formula from 12:10 doesn't work check this:
=IF(A3=B3;"1"; "0")
or if you have other excel language translate ,,IF" to your native word meaning English "if". For Polish it is 'jeżeli" so in polish lang. Excel formula should be:
,, =JEŻELI(A2=B2;"1"; "0") "
,, =IF(A2=B2;"1"; "0") " will DO NOT work
It’s very clear the Tutor did manually type some names in the Remove duplicates part because if we Pause the video at 12.51 and look over to the Promotion Column First Value= “Adelaide L Harrop “ and then match it with Employee name Retrenchment column value in cell 10 we see the same name Adelaide L Harrop and to which the find duplicates column says “N”.
Quite funny.
Brother, there is no manual name typing, everything is dynamic.
@@datalab365 Don't think people watching your videos to learn are fools... It's very much evident that the video was edited and those values were manually typed.. You can go back on your video, pause it at 12.51 and refer the 2 column and see for yourself the Duplicate name in column 1 and column 2 being same , just the cell no.s are different which obviously IF function will never be able to give back the result as duplicate as it will only refer values in cells of same row...
And mind you there were 54 duplicate values( when the names of both column are put in one single column and then remove duplicate option is utilised.
Unfortunately UA-cam doesn't allow screenshot to be uploaded otherwise i would have given a evidence of how where you are wrong and deliberately not accepting it...
@@datalab365 The first part of your video on this Report was no doubt Superb . But in this part almost all people who have commented did face issues in Excel Duplicate part which can only be possible if some editing has been done in the sheet but obviously not made public..
I did read a few comments where the
1. end result was different to what you got and so on.....
@@soodvarun20 I will urge you to watch the excel version to see how I made everything, it will help.
I use a formula to determine everything
@@datalab365 So i think you used the If(And) function to get the names.
But it only returns the names as Duplicate if the name in column 1 ( Row 2) is same as name in Column 2(Row 2).
On contrary it gives the result as Not Duplicate if the same in Column 1(Row 2) is present in Column 2 (Row 3).
On the final note the function used if( and) function gives a list of 4 employees, names of which are totally different to what you got obviously through some manually typed names in the list that's why the video is obviously edited at that stage .
I need employs excel data
hi sir im getting performance high rating low error plze expla
Something might be wrong with your DAX code, watch it over again.
No sir i checked more time
@@jayashree4745 type your DAX Code here let me see what happens
High emp rating=calculate ([total emp], 'hr analytical data'[performance Rating]="High rating")
@@jayashree4745 check the datatype of your performance rating to make sure is a text.
Add filter function after [total emo]
Calculate([total emo],
Filter(hr analytics data[ performance rating ] ="High rating"
)
Top❤
🙏
I got 54 duplicates, what did I do wrong
part-3 ?
Hello sir , can you just clarify in this video how % high rated and % low rated has been created Because when i am trying to show this visual it shows :
MdxScript(Model) (19, 57) Calculation error in measure 'All Measures'[High Rated]: DAX comparison operations do not support comparing values of type Integer with values of type Text. Consider using the VALUE or FORMAT function to convert one of the values.
Please Tell me.
Create measures for high and low rated first then branch out to calculate the percentages.
That is you will have to divide either high rating or low rating by the total employees using the divide function.
Hope this is clear, let me know if I can assist further.
Am i the only one facing problem in excel sheet ? #data_mismatch
do reply if anyone know the solution.
Background Music is very Annoying
Sorry, please.
Can you pelase explain how to do the navigation tab ??
Sure, would make a video for that