Notifications
Clear all
Power Query
2
Posts
2
Users
0
Reactions
69
Views
Hi Everyone,
Need help with a complex (to me) Conditional Column.
Looking at the example, I need IF the DC date is null and if the Acct. Number is the same to fill in each instance of the acct number then stop.
However if there is an account number and no DC date do nothing.
Does that make sense?
| Account Number | DC Date |
| 123456 | 7/4/2018 |
| 123456 | null |
| 123456 | null |
Thank you!
Posted : 17/05/2019 8:10 am
Hi Karla,
Is it possible that you'll have an account number with multiple DC dates, or only ever one? If the latter then you can duplicate this query and filter the DC date column to remove rows containing null.
Then you can merge the two tables bringing in the DC date to all rows based on the account number.
If the former, please provide an Excel file with a bigger data set that allows for all scenarios.
Mynda
Posted : 17/05/2019 6:36 pm
