Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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...
Need Help
Show and Tell
  • Anonymous's avatar
    Anonymous
    6 years ago

    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