Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to 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.
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.
Have you looked at the attachment from my previous post?