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.
May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.
Thank you.