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! Request now

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,250 Views
0
52 REPLIES 52
SRP
Frequent Visitor

‎04-11-2021 04:26 AM

Hello, i still need help 🙂

Message 53 of 53
1,552 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,657 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,636 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,599 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,599 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,599 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,600 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,602 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,601 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,601 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,601 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,601 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,601 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,597 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,596 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,596 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,596 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,596 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,597 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,597 Views
0

Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

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

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!

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