Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
SRP
Frequent Visitor

How to regroup two tables effectively ?

‎04-05-2021 05:24 PM

Hello everyone !

 

I have a problem i can't solve

 

The link

 

I have three tables : 

 

The first with every articles views on one month

The second with every views for every article

The third with every article on my database (half has 0 views)

 

I want to regroup to have every views in one table and when the article has 0 views, the number is 0 in "number of views for this article". I don't know how to do that, maybe with related ?

 

Sorry for my english, i hope you can understand and help me !

Labels:
Message 1 of 53
2,378 Views
0
52 REPLIES 52
SRP
Frequent Visitor

‎04-11-2021 04:26 AM

Hello, i still need help 🙂

Message 53 of 53
1,650 Views
0
Ashish_Mathur
Super User
Super User

‎04-05-2021 07:23 PM

Hi,

Share 3 simple datasets and show the expected result.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
Message 2 of 53
1,755 Views
0
SRP
Frequent Visitor
In response to Ashish_Mathur

‎04-06-2021 01:08 AM

What do you mean by share, do you want me to update a file with my data ? I'm not sure if you saw but i have posted a screen with the problem 

Message 3 of 53
1,734 Views
0
Syndicate_Admin
Administrator
Administrator
In response to SRP

‎04-06-2021 03:30 AM

A screenshot doesn't help at all. I need a file to work with. You can share 3 simple datasets and display the expected result in a simple Excel file. Share the download link for the Excel file.

Message 52 of 53
1,697 Views
0
Syndicate_Admin
Administrator
Administrator
In response to SRP

‎04-06-2021 03:25 AM

A screenshot doesn't help at all. I need a file to work with. You can share 3 simple datasets and display the expected result in a simple Excel file. Share the download link for the Excel file.

Message 51 of 53
1,697 Views
0
Syndicate_Admin
Administrator
Administrator
In response to SRP

‎04-06-2021 03:22 AM

A screenshot doesn't help at all. I need a file to work with. You can share 3 simple datasets and display the expected result in a simple Excel file. Share the download link for the Excel file.

Message 50 of 53
1,697 Views
0
Syndicate_Admin
Administrator
Administrator
In response to SRP

‎04-06-2021 03:20 AM

A screenshot doesn't help at all. I need a file to work with. You can share 3 simple datasets and display the expected result in a simple Excel file. Share the download link for the Excel file.

Message 48 of 53
1,698 Views
0
SRP
Frequent Visitor
In response to Syndicate_Admin

‎04-06-2021 03:26 AM

I think you may have a problem with this account aha. If u need the file here : https://we.tl/t-3tM7ffs3Hh

Message 49 of 53
1,700 Views
0
Syndicate_Admin
Administrator
Administrator
In response to SRP

‎04-06-2021 03:17 AM

A screenshot doesn't help at all. I need a file to work with. You can share 3 simple datasets and display the expected result in a simple Excel file. Share the download link for the Excel file.

Message 47 of 53
1,699 Views
0
Syndicate_Admin
Administrator
Administrator
In response to SRP

‎04-06-2021 03:14 AM

A screenshot doesn't help at all. I need a file to work with. You can share 3 simple datasets and display the expected result in a simple Excel file. Share the download link for the Excel file.

Message 46 of 53
1,699 Views
0
Syndicate_Admin
Administrator
Administrator
In response to SRP

‎04-06-2021 03:11 AM

A screenshot doesn't help at all. I need a file to work with. You can share 3 simple datasets and display the expected result in a simple Excel file. Share the download link for the Excel file.

Message 45 of 53
1,699 Views
0
Syndicate_Admin
Administrator
Administrator
In response to SRP

‎04-06-2021 03:09 AM

A screenshot doesn't help at all. I need a file to work with. You can share 3 simple datasets and display the expected result in a simple Excel file. Share the download link for the Excel file.

Message 44 of 53
1,699 Views
0
Syndicate_Admin
Administrator
Administrator
In response to SRP

‎04-06-2021 03:06 AM

A screenshot doesn't help at all. I need a file to work with. You can share 3 simple datasets and display the expected result in a simple Excel file. Share the download link for the Excel file.

Message 43 of 53
1,699 Views
0
Syndicate_Admin
Administrator
Administrator
In response to SRP

‎04-06-2021 03:03 AM

A screenshot doesn't help at all. I need a file to work with. You can share 3 simple datasets and display the expected result in a simple Excel file. Share the download link for the Excel file.

Message 42 of 53
1,695 Views
0
Syndicate_Admin
Administrator
Administrator
In response to SRP

‎04-06-2021 03:00 AM

A screenshot doesn't help at all. I need a file to work with. You can share 3 simple datasets and display the expected result in a simple Excel file. Share the download link for the Excel file.

Message 41 of 53
1,694 Views
0
Syndicate_Admin
Administrator
Administrator
In response to SRP

‎04-06-2021 02:57 AM

A screenshot doesn't help at all. I need a file to work with. You can share 3 simple datasets and display the expected result in a simple Excel file. Share the download link for the Excel file.

Message 40 of 53
1,694 Views
0
Syndicate_Admin
Administrator
Administrator
In response to SRP

‎04-06-2021 02:54 AM

A screenshot doesn't help at all. I need a file to work with. You can share 3 simple datasets and display the expected result in a simple Excel file. Share the download link for the Excel file.

Message 39 of 53
1,694 Views
0
Syndicate_Admin
Administrator
Administrator
In response to SRP

‎04-06-2021 02:52 AM

A screenshot doesn't help at all. I need a file to work with. You can share 3 simple datasets and display the expected result in a simple Excel file. Share the download link for the Excel file.

Message 38 of 53
1,694 Views
0
Syndicate_Admin
Administrator
Administrator
In response to SRP

‎04-06-2021 02:49 AM

A screenshot doesn't help at all. I need a file to work with. You can share 3 simple datasets and display the expected result in a simple Excel file. Share the download link for the Excel file.

Message 37 of 53
1,695 Views
0
Syndicate_Admin
Administrator
Administrator
In response to SRP

‎04-06-2021 02:47 AM

A screenshot doesn't help at all. I need a file to work with. You can share 3 simple datasets and display the expected result in a simple Excel file. Share the download link for the Excel file.

Message 36 of 53
1,695 Views
0

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

View All