Max date from 2 columns for each record and display last 6 months data

[prashantnegi]

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 · Accepted solution]

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.

[prashantnegi · Accepted solution]

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.

[Mariusz]

Hi @prashantnegi 

Have you looked at the attachment from my previous post?

Best Regards,
Mariusz

Please feel free to connect with me.

[prashantnegi]

Hi @Mariusz,

Thanks for the solution. I was confused but got your solution.

[Mariusz · Accepted solution]

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.