Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Summary Table from Main Data Set

Hi Experts

 

I have a master table was i have uploaded into POwer BI, i want to creat a summary table based on Column Time, and Obersavation count...the trick here is i want the summary table to be driving using the following DAX and add other columns to the summary table as and when required.

 

result table =
ADDCOLUMNS (
    FILTER (
        CALENDAR ( MIN ( Sample1[Time] ), MAX ( Sample1[Time] ) ),
        DAY ( [Date] ) = 1
    ),
    "observations", CALCULATE (
        SUM ( Sample1[Observations] ),
        FILTER (
            Sample1,
            Sample1[Time].[Year] = YEAR ( EARLIER ( [Date] ) )
                && Sample1[Time].[MonthNo] = MONTH ( EARLIER ( [Date] ) )
        )
    ) + 0
)

2 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable

      HI Yu Gu... I have managed to solve the problem through trial and error. Is there a way to delete the question?