I am importing my CSV file into Power Bi. I have 6 columns that have milestone dates, starts and finishes. What I am trying to do is after I add a custom column I need to have a formula look at the start date to see if there is a value. If there is not grab the value from the finish column. Can someone help me with the formula please. The next formula is for Actual Start and Actual Finish. Neither one of those will have a date until the activity is started then finished. That formula would have to be multi conditional.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
CSV Import Transform To Fill In Dates
- Thread starter benntw
- Start date
Excel Facts
Remove leading & trailing spaces
Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().
Similar threads
- Replies
- 2
- Views
- 377
- Question
- Replies
- 1
- Views
- 440
- Replies
- 2
- Views
- 587
