Forum Discussion
Solved
Calculating a date based on one variable in data
Hi all - I have some data (see sample). I need to be able to produce a derived column in the dataset based on whatever the field is in column B (Type). If it's Activity, then the date needs to show...
This should be pretty straighforward either with DAX or Power Query unles you 're looking for something else.
Use Power Query. Go to the Add Column tab and choose Conditional Column. There you can plug in the values you need.