I know that to simply show project durations, I could use a Gantt chart controls, but I don't think I can accomplish something like this that has multiple conditions. Now, only using the ProjectData.xlsx which I get from the aforementioned other department, I would like to recreate this in PowerBI. If the project duration is 10 days, cell content is "Long"įor example, the formula for D2 would look like this:.If the date in the column (D1, E1 etc.) is between and ,.The "Long", "Short", and "-" is decided using the following criteria:.Here I set the time period for 2 weeks, but in reality, it would go on for a year. Cells E1, F1 etc are advanced by one day.We get this every week, and using this, we calculate an Excel gantt chart of sorts, based on several conditions. It's a project start and end date table, which I get from a different department in our company. I have a source data Excel that looks like this. In the first row, under Field Name, enter ID, and in the first row under Width, enter a zero (0).
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |