Forum Discussion
How to create sub table based on other table
Hi, I am syncrhonizing data from VSTS (Azure Devops) - Analytics View. I want to create a table based on last 30 days historical table which I fetch from Analytics plugin. I was able to b...
Hi Anonymous ,
You can try to use following calculate table formula to create a expand table with all detail date records:
New Table = VAR _calendar = CALENDAR ( MIN ( Table[Iteration Start Date] ), MAX ( Table[Iteration End Date] ) ) RETURN FILTER ( CROSSJOIN ( SUMMARIZE ( Table, [Path], [Iteration Start Date], [Iteration End Date] ), _calendar ), [Date] >= [Iteration Start Date] && [Date] <= [Iteration End Date] )Regards,
Xiaoxin Sheng
Hi Anonymous ,
You can try to use following calculate table formula to create a expand table with all detail date records:
New Table =
VAR _calendar =
CALENDAR (
MIN ( Table[Iteration Start Date] ),
MAX ( Table[Iteration End Date] )
)
RETURN
FILTER (
CROSSJOIN (
SUMMARIZE ( Table, [Path], [Iteration Start Date], [Iteration End Date] ),
_calendar
),
[Date] >= [Iteration Start Date]
&& [Date] <= [Iteration End Date]
)
Regards,
Xiaoxin Sheng
Thanks for help Anonymous ! This is exactly what I needed.