Map Dates to Employee Life Cycle | Power BI Challenge
Вставка
- Опубліковано 5 сер 2024
- ➜ Download Data - goodly.co.in/wp-content/uploa...
➜ Post Your Answers Here 📰 - goodly.co.in/map-dates-to-emp...
===== ONLINE COURSES =====
✔️ Mastering DAX in Power BI -
goodly.co.in/learn-dax-powerbi/
✔️ Power Query Course-
goodly.co.in/learn-power-query/
✔️ Master Excel Step by Step-
goodly.co.in/learn-excel/
✔️ Business Intelligence Dashboards-
goodly.co.in/learn-excel-dash...
===== LINKS 🔗 =====
Blog 📰 - www.goodly.co.in/blog/
Corporate Training 👨🏫 - www.goodly.co.in/training/
Need my help on a Project 💻- www.goodly.co.in/consulting/
===== CONTACT 🌐 =====
Twitter - / chandeep2786
LinkedIn - / chandeepchhabra
Email - goodly.wordpress@gmail.com
===== CHAPTERS =====
0:00 Intro
0:24 Explaining the Data & the Problem
2:22 Expected Output
3:05 Rules
===== WHO AM I? =====
A lot of people think that my name is Goodly, it's NOT ;)
My name is Chandeep. Goodly is my full-time venture where I share what I learn about Excel and Power BI.
Please browse around, you'd find a ton of interesting videos that I have created :) Cheers!
- - - - -
Music By: "After The Fall"
Track Name: "Tears Of Gaia"
Published by: Chill Out Records
- Source: goo.gl/fh3rEJ
Official After The Fall UA-cam Channel Below
ua-cam.com/channels/GQE.html...
License: Creative Commons Attribution-ShareAlike 4.0 International (CC BY-SA 4.0)
Full license here: creativecommons.org/licenses - Наука та технологія
WOW! This is fascinating. You've got me thinking. 💡
Go for it! Oz
I would use the following steps --
1. Create a calculated end date column, using calculate -- I would calculate the MIN Date for each employee where Date >= variable current Date (date for the selected record)
2. Subtract one day from the step 1
3. Then I would use Generate Dax Function to create all date records between the date range (Date column and newly calculated end date column)
Kindly request you to also please cover---
Calculate age for each position/Client he is in..
He might come back to Client 2 after going to Client 4 the total age of Client 2 position...
This helps in calculating age of a ticket in suport industry,
Age of an employment in particular team or organization in HR...
This would be a great answer for so many datasets (Salesforce - Case Age, Oracle Fusion - Employee history)
Hi, I need to calculate dates between start date and end date of week.could you please help me out.
What about if i solve using excel instead of Power BI?
Ah... there you go, Chandeep... Waiting to see the solutions... :)
However, there was an important caveat... If the last event in an employee's lifecycle is "Employee Offboarding," the calculated dates should not go beyond that point.
For now I kept it clean, I am sure you can tweak the solution :)
@@GoodlyChandeep Alright... :)
Chandeep - one question. If the last event for an employee is not offboarding, what do we assume the end date for that event is? The max date in the dataset? Today's date? Other? Thanks!
To keep the problem simple, any last event is currently ongoing. Therefore Today's Date.
@@GoodlyChandeep Damn - I guessed wrong. Back to the advanced editor... : )
Thanks for the clarification.
A genius, I have ever seen for POWER BI... Take a Bow.
Thank you 💚
@@GoodlyChandeep can you please make a video on how to get sales for the Desired set of dates in a month. Dynamically. Ex. Apr - 15 days or dates 15-30 like that. But Not for last 15 days, last one week.
Sir I want to create modle where 50 daily moving average price cores the 200 day moving avg price for share price can you make video on this plss
I've got a solution. It takes me 10 separate queries, but it's a solution.
This will be my next video.
I'll upload 2 solutions on Sunday.
- DAX solution requires no Power Query and
- Power Query solution requires no DAX.