Reply
Frequent Visitor
Posts: 7
Registered: ‎10-26-2018
Accepted Solution

Update data automatic form table daily to table monthly


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?

daily to monthly.JPG

View attachments

 

Thank you!!!


Accepted Solutions
Community Support Team
Posts: 1,097
Registered: ‎07-25-2018

Re: Update data automatic form table daily to table monthly

Hi @nmhung49

 

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

1.png

 

Regards,

Cherie

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post


All Replies
Super Contributor
Posts: 743
Registered: ‎06-23-2016

Re: Update data automatic form table daily to table monthly

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

Community Support Team
Posts: 1,097
Registered: ‎07-25-2018

Re: Update data automatic form table daily to table monthly

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

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Frequent Visitor
Posts: 7
Registered: ‎10-26-2018

Re: Update data automatic form table daily to table monthly


@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

Community Support Team
Posts: 1,097
Registered: ‎07-25-2018

Re: Update data automatic form table daily to table monthly

Hi @nmhung49

 

You may refer to this sample file.

 

Regards,

Cherie

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Frequent Visitor
Posts: 7
Registered: ‎10-26-2018

Re: Update data automatic form table daily to table monthly


@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

 

Sample.JPG

Community Support Team
Posts: 1,097
Registered: ‎07-25-2018

Re: Update data automatic form table daily to table monthly

Hi @nmhung49

 

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

1.png

 

Regards,

Cherie

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.