Summary Table from Main Data Set

[Anonymous]

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
)

[v-yulgu-msft · Accepted solution]

Hi @Anonymous ,

It would be better you could provide sample data and desired output so that I can test.

How to Get Your Question Answered Quickly

Best regards,

Yuliana Gu

[Anonymous]

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