CSV Import Transform To Fill In Dates

B

benntw

Board Regular
Joined
Feb 17, 2014
Messages
222
Office Version
  1. 365
Platform
  1. Windows
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.
 

Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest
You must log in or register to reply here.

Similar threads

J
  • Question Question
Importing multiple JSON files into useable Excel format.
Replies
2
Views
254
jimbomcmucka
J
P
  • Question Question
Add Column and Fill Rows with the As of Date/Time on the Exported File
Replies
1
Views
425
Matt Allington
M
B
  • Question Question
Import entire Folder as text
Replies
6
Views
316
bobaol
B
A
  • Question Question
utilisation chart for employee FTE's
Replies
0
Views
459
ajm
A
earthworm
  • Question Question
Importing data from Folder through Power Query
2
Replies
12
Views
1K
earthworm
earthworm

Forum statistics

Threads
1,223,649
Messages
6,173,585
Members
452,522
Latest member
saeedfiroozei

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top