Skip to main content
cancel
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
Anonymous
Not applicable

For each element of a table, I want all distinct element of another table

Hello, 

I have two tables (they are simplified for the exemple) 
This first one is a table who contains Date : 

 

DATE 
1.01
2.01
3.01

 

The second table contains some Operations in bulk (four distinct operation) : 

 

OPERATION 
Honage
Honage
Frittage
Frittage
Honage
Centerless
Centerlss
Honage
Frittage
Brossage


The result needed : 

 

DATE OPERATION 
1.01Honage
1.01Frittage
1.01Centerless
1.01Brossage
2.01Honage
2.01Frittage
2.01Ceterless
2.01Brossage
3.01Honage
3.01Frittage
3.01Ceterless
3.01Brossage

 

As shown above, the result I want to have is the following  : For each date of the first table, I want all distinct operation of the other one.


So in this case, for the first date (01.01) I would have four raws (number of distinct operation), and so on for each date. 

It's something I need to create for further measure. 

 

I do not manage to do it. It would be really kind if someone could help me on this. 
Thank you very much


Noah 

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@Anonymous , Based on what I got

 

Crossjoin(Distinct(Table1[DATE]), Distinct(Table2[OPERATION]))

 

or

 

gerenerate(Distinct(Table1[DATE]), Distinct(Table2[OPERATION]))

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

View solution in original post

2 REPLIES 2
amitchandak
Super User
Super User

@Anonymous , Based on what I got

 

Crossjoin(Distinct(Table1[DATE]), Distinct(Table2[OPERATION]))

 

or

 

gerenerate(Distinct(Table1[DATE]), Distinct(Table2[OPERATION]))

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube
Anonymous
Not applicable

Tank you very much ! I'd never though of such a fast answer. @amitchandak 

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.

Top Solution Authors