I want to ask some questions I currently have: Is it possible to have some way to get dates of this week? For example, I have different tasks each day of a month, and I want to filter to show this week only, how could I go doing that? In the case for showing by this month, would some function like MONTH(Today()) = MONTH(<date>) work?
The second part of the question is: I have task from a project, where the start and end date of 'parent' task are based on the start/end date of the subtasks on it. For example:
|Project||Task||Subtask||Sub subtask||Start date||End date|
As can be seen, the project start/end date is based upon the start/end date of its task/sub task/sub subtask. In this case, the start date of "LP" is the minimum date of the items in "task" and end date is the max of those items. In the same way, the minimum date of the items in "task" is based upon the ones in "subtask" and, if have another level, in subsubtasks. What I want to know, is there some way so if for example, I changed the "Opening-finish" end date, it would automatically update that date in "go date" (for example, it is now 19-06-2020), and since it is a new 'max', it would change the end date of 'execution' and then the one of the project itself.
Solved! Go to Solution.
In a gallery, actually. For some reason now that I have closed/opened the app, I can select the proper item ('Comienzo Plan' or 'Fin Plan'), but before that it only showed datacards from other screens.
For anyone wanting to know end formula, will post image following this text, since in 'code bar' ends not readable, IMO.
So it sounds like the ol' "things are not working like they should" - "exit and then go back in, and all is better" syndrome.
I assume then it is working properly for you now?
Check out new user group experience and if you are a leader please create your group
Did you know that you can visit the Power Query Forum in Power BI and now Power Apps
Participate in the Power Virtual Agents Community Challenge
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.