Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.