Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi @Idrissshatila I have two tables, one with Employee Name and Employee code and other with Employee code,dates, amount and other detaitails. I want to create a new column which can show which employee worked for how many days so i can calculate earing per day of an employee.
Okay so you go in the second table and you create a new column as the following
Number of days =
DATEDIFF ( startingDate, TODAY (), DAY )
this new column will give you number of days for each row between the date that in in the table and today. Then you can visualise it with employee name.
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Proud to be a Super User! | |
@Idrissshatila Expression.Error: The name 'DATEDIFF' wasn't recognized. Make sure it's spelled correctly.
@shamsul, can you show me the formula you wrote without showing any sensitive data please?
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Proud to be a Super User! | |
@Idrissshatila table 1
employee id | name | payroll_enrollment_id |
4 | Karan | 14 |
325 | RANI.S | 2612 |
326 | SWETHA.T | 2545 |
327 | MEENAKSHI.S | 2453 |
329 | MANGALESWARI.S | 2517 |
332 | A.R | 2118 |
334 | VASANTHI.R | 2089 |
337 | MUTHURAKKU.M | 2198 |
339 | MUTHULAKSHMI.S | 2481 |
340 | GIRIJA | 2649 |
345 | MAHALAKSHMI.S | 2711 |
346 | MUTHULAKSHMI.P | 2419 |
347 | RAJESWARI.K | 524 |
348 | VANITHA.C | 2366 |
349 | R.SUSILA | 518 |
Hello @shamsul ,
Can you provide more details so we could help you ?
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Proud to be a Super User! | |
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
126 | |
105 | |
103 | |
81 | |
72 |