Solved: Max date from 2 columns for each record and displa...

prashantnegi · ‎08-30-2019

Hello All,

I am a beginner of PowerBI. I have some data like:

Emp Name Skill Name Manager Upd Date Employee Upd Date
Raj Skill 1 06-Aug-2017 04-AUG-2017
Rahul Skill 2 12-May-2018 12-May-2018
Manoj Skill 1 06-Apr-2019 10-Apr-2018
Roy Skill 2 09-June-2019 12-June-2018

From above data I want to display last 6 months data based on Manager and Employee Upd Date by finding the max date of the two and using the max date for showing data for last 6 months (Each record should have a max date out of Manager and Employee Upd Dates). Please help and thanks in advance.

Mariusz · ‎08-30-2019

Hi @prashantnegi

On the attached, you will find a file with a solution applied to your scenerio.

Let me know if that is what you needed.

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.

View solution in original post

prashantnegi · ‎08-30-2019

Hi @Mariusz,

Thanks for the reply. Yes this is what I want. I have 4 columns as mentioned in the question, so I wanted to create a custom column for finding out the max date among the 2 columns namely manager and employee updated dates for each record. Can you please help me with the formula to use for this custom column to show the max date.

View solution in original post

prashantnegi · ‎08-30-2019

Hi @Mariusz,

Thanks for the reply. Yes this is what I want. I have 4 columns as mentioned in the question, so I wanted to create a custom column for finding out the max date among the 2 columns namely manager and employee updated dates for each record. Can you please help me with the formula to use for this custom column to show the max date.