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.
Hello Creative_tree88,
create a calculated column
Derived_date_column=
if([Type]="Activity",[Event Date],[Request Date])
if this hepls , please mark as solution