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.
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?
Solved! Go to 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])
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?
@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?
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.
User | Count |
---|---|
113 | |
97 | |
80 | |
69 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |