Project start date and End date

[vjnvinod]

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?

Project Start date = MINX('FCC Resource Plan','FCC Resource Plan'[Booking Date].[Date])

[amitchandak · Accepted solution]

@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])

[vjnvinod]

@amitchandak 

Fantastic, how about for the end date coloumn, how should be the formula?

[amitchandak · Accepted solution]

@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])

[vjnvinod]

@amitchandak 

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"

[vjnvinod · Accepted solution]

@amitchandak 

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])