Forum Discussion
Attempting to dynamically split querry data to show reports
So I have big excel tables that contain information on a varying amount of projects(they get grouped by main location then into sub projects) Every project has the same check points in the same order with the respective time and progress information.
I want to take this massve table and dynamically slice it up to show every project individually on a different page. every project can be displayed with the same dashboard so it would require making a vizualization page template and repeating it for every project I split into.
If anyone has any knowledge or ideas I would really appreciate it.
Cheers,
Kiernan
The project data looks something like this:
Gate Start Finish
Area 1/1/1 2/2/21
1 1/1/1 2/2/2
1-1 1/1/1 1/1/4
1-2 1/1/4 2/2/2
2 1/1/6 2/2/21
2-1 1/1/6 1/1/21
2-2 1/1/21 2/2/21
...
2 Replies
v-yuta-msftCommunity Support
Anonymous ,
So I have big excel tables that contain information on a varying amount of projects(they get grouped by main location then into sub projects) Every project has the same check points in the same order with the respective time and progress information.
I want to take this massve table and dynamically slice it up to show every project individually on a different page. every project can be displayed with the same dashboard so it would require making a vizualization page template and repeating it for every project I split into.
What does "projects", "sub projects", "main location", "check points", "respective time" and "progress information" mean? I could not find any corresponding info in your sample table.
Regards,
Jimmy Tao
Sorry that sample table is basic and is a random example I just hand wrote, its not actually the data im working with.
Esentially our company catogorizes our projects by their location, so comunity A would hold all projects within itself. The reports we have are pulled by area. So a report for community A would look like this:
Community A Ovrl Start Ovrl End GoalDuration
Project1 Start End GoalDuration
milestone 1 Start End GoalDuration
milestone 2 Start End GoalDuration
Project2 Start End GoalDuration
milestone 1 Start End GoalDuration
milestone 2 Start End GoalDuration
Theres more information but what I care about is the time it took for the milestone vs the time we should take for each milestone. I already have a function for that in DAX but what I am having trouble with is with this big data table, I dont know how many projects I have. Is there a way to split this table into different querries weather I have 10 entries or 1000?
Sorry I was using check points interchangably with milestones, the milestone would be that row, so as an example if a project was buildign a building it would look like this:
Building Building 1/1/1 2/2/2
Design 1/1/1 1/1/16
Build 1/1/16 1/1/31
Furnish 1/1/31 2/2/2
Let me know if this makes sense, sorry again for the confusion