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])
works like a charm
how about end date, something similar?
But i have to exclude "No Booking" from coloumn booking type for End date
that means Project end date should be by excluding the max dates of "no booking"
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])