Update data automatic form table daily to table monthly

[nmhung49]

I have 2 table daily and monthly, I want update data automatic form table daily to table montly in power BI desktop

How do I do that?

View attachments

Thank you!!!

[v-cherch-msft]

Hi @nmhung49

Below is the document about 'Group by' Function in Query Editor for your reference.

https://docs.microsoft.com/en-us/power-bi/desktop-common-query-tasks#group-rows

Regards,

Cherie

[Stachu]

in the query editor you can make table Monthly a reference to table Daily and then use groupby and sum on Sales

if you just want to show monthly table in the visual then you can drag & drop table Monthly
to rows: Month and Branch

to values: Sale
in the Table visual, and the result will be the same

[nmhung49]

---

@Stachu wrote:

in the query editor you can make table Monthly a reference to table Daily and then use groupby and sum on Sales

if you just want to show monthly table in the visual then you can drag & drop table Monthly
to rows: Month and Branch

to values: Sale
in the Table visual, and the result will be the same

---

You can make a example?

Attach File

Thank you

[v-cherch-msft]

Hi @nmhung49

You may refer to this sample file.

Regards,

Cherie

[nmhung49]

---

@v-cherch-msft wrote:

Hi @nmhung49

You may refer to this sample file.

Regards,

Cherie

---

Hi @v-cherch-msft

Thank you for your help

I wan to combine data table daily -> Monthly and Table Monthly to create Table Result

You see to this sample file

How do I do it ?

Same this picture

[v-cherch-msft · Accepted solution]

Hi @nmhung49

You may use 'Append Queries' in Query editor. Make sure the 2 tables' column names are matched.

Regards,

Cherie