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.
Let me know if this is essentially what you're looking for. I accomplished this by uploading 3 bits of data. Employee, Hire Date, Term Date. REst of the columns are calculated columns. Status looking for a blank in term date field. Months w/ Company is simple math - (TODAY - HireDate) essentially. Award is a nested IF Statement - If status = Inactive then "".
Let me know if this helps, and if more information is needed.
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 |
---|---|
47 | |
26 | |
19 | |
14 | |
10 |
User | Count |
---|---|
57 | |
49 | |
44 | |
18 | |
18 |