Forum Discussion
Solved
Project start date and End date
Dear Experts, I have a table "FCC Resource Plan" where the details of the resources along with their date of booking is available by various days what i need is to 2 coloumn(Project start date a...
vjnvinod , Try a new column like, assume you have the project id
Project Start date = MINX(filter( 'FCC Resource Plan',[project id] = earlier([project id]) ) , 'FCC Resource Plan'[Booking Date].[Date])
is there anything you can help me on this?
I tweaked your formula, but i have exclude the no booking dates as well, how do we modify this DAX?
Project End date2 = MAXX(filter( 'FCC Resource Plan',[GPN number] = earlier([GPN number]) ) , 'FCC Resource Plan'[Booking Date].[Date])
