Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
I have a file that has employee ID's Training Dates and Start Dates. I need to create a new column that will populate the training date if the training date is greater than or equal to the Start Date, otherwise leave the rows blank.
Example below, Please note that the Training date is a measure the others are columns. I am attempting to create the Trained Column as a Calculated Column.
Empl_id | Training Date | Start Date | Trained |
AB123 | 4/5/2022 | ||
AB123 | 4/6/2022 | ||
AB123 | 4/7/2022 | ||
AB123 | 4/8/2022 | ||
AB123 | 4/9/2022 | ||
AB123 | 4/10/2022 | ||
AB123 | 4/11/2022 | ||
AB123 | 4/12/2022 | ||
AB123 | 4/13/2022 | ||
AB123 | 4/14/2022 | ||
AB123 | 4/15/2022 | ||
AB123 | 4/16/2022 | 4/16/2022 | 4/16/2022 |
AB123 | 4/17/2022 | 4/16/2022 | |
AB123 | 4/18/2022 | 4/16/2022 | |
AB123 | 4/19/2022 | 4/16/2022 | |
AB123 | 4/20/2022 | 4/16/2022 | |
AB123 | 4/21/2022 | 4/16/2022 | |
AB123 | 4/22/2022 | 4/16/2022 | |
BC456 | 4/19/2022 | ||
BC456 | 4/20/2022 | ||
BC456 | 4/21/2022 | ||
BC456 | 4/22/2022 | ||
BC456 | 4/23/2022 | 4/23/2022 | 4/23/2022 |
BC456 | 4/24/2022 | 4/23/2022 | |
BC456 | 4/25/2022 | 4/23/2022 | |
BC456 | 4/26/2022 | 4/23/2022 | |
Column | Measure | Column | Column |
Solved! Go to Solution.
Is this what you are looking for?
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.