Forum Discussion
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 and Project End date) from Booking Date coloumn
for project start date, i tried using the Dax below, but this is not correct, as the lines are repeating in all rows and values are same across all rows
Ideally it should iterate through each resources and show the min of that resources booking date only
how to write this calculated coloumn correctly or is it has to be done through measure?
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])
4 Replies
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])
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])