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: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! 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,167 Views
0
52 REPLIES 52
Syndicate_Admin
Administrator
Administrator
In response to SRP

‎04-06-2021 01:58 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 14 of 53
202 Views
0
Syndicate_Admin
Administrator
Administrator
In response to SRP

‎04-06-2021 01:56 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 13 of 53
204 Views
0
Syndicate_Admin
Administrator
Administrator
In response to SRP

‎04-06-2021 01: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 12 of 53
207 Views
0
Syndicate_Admin
Administrator
Administrator
In response to SRP

‎04-06-2021 01: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 11 of 53
220 Views
0
Syndicate_Admin
Administrator
Administrator
In response to SRP

‎04-06-2021 01:50 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 10 of 53
225 Views
0
Syndicate_Admin
Administrator
Administrator
In response to SRP

‎04-06-2021 01: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 9 of 53
225 Views
0
Syndicate_Admin
Administrator
Administrator
In response to SRP

‎04-06-2021 01:45 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 8 of 53
224 Views
0
Syndicate_Admin
Administrator
Administrator
In response to SRP

‎04-06-2021 01:43 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 7 of 53
227 Views
0
Syndicate_Admin
Administrator
Administrator
In response to SRP

‎04-06-2021 01:41 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 6 of 53
228 Views
0
Ashish_Mathur
Super User
Super User
In response to SRP

‎04-06-2021 01:39 AM

A screenshot does not help at all.  I need a file to work with.  You may share 3 simple datasets and show the expected result in a simple Excel file.  Share the download link of the Excel file.


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

‎04-06-2021 03:25 AM

Here the file : https://we.tl/t-3tM7ffs3Hh

 

I don't know how to "combine"

Message 5 of 53
198 Views
0

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

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
Top Solution Authors
View All