Does table generated from summarize gets updated automatically

[jatneerjat]

Hi,

I have created a table using summarize() function.so whenever my dataset updated does the table generated through summarize() also gets updated.

Thanks

[v-jiascu-msft]

Hi @jatneerjat,

Yes, it will update automatically. Please give it a try.

Best Regards,

Dale

[jatneerjat]

Thanks @v-jiascu-msft.It works.

Do I have to create 2 summarized table if i want to group by 2 different columns by a column ID?

Thanks

[v-jiascu-msft · Accepted solution]

Hi @jatneerjat,

I don't think so. It could be done easily like below. One table is enough. If you want more details, maybe you can provide a sample data.

summarizeTable =
SUMMARIZE (
    'table',
    'table'[column ID],
    "value1", SUM ( 'table'[column1] ),
    "value2", SUM ( 'table'[column2] )
)

Best Regards,

Dale

[jatneerjat]

Thanks alot @v-jiascu-msft.

its simple.

Thanks,

Jat