Reply
Frequent Visitor
Posts: 4
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
Super Contributor
Posts: 650
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

View solution in original post


All Replies
Super Contributor
Posts: 672
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

Super Contributor
Posts: 650
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

Frequent Visitor
Posts: 4
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

Super Contributor
Posts: 650
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

Highlighted
Frequent Visitor
Posts: 4
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

Super Contributor
Posts: 650
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