Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
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.01 | Honage |
| 1.01 | Frittage |
| 1.01 | Centerless |
| 1.01 | Brossage |
| 2.01 | Honage |
| 2.01 | Frittage |
| 2.01 | Ceterless |
| 2.01 | Brossage |
| 3.01 | Honage |
| 3.01 | Frittage |
| 3.01 | Ceterless |
| 3.01 | Brossage |
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
Solved! Go to Solution.
@Anonymous , Based on what I got
Crossjoin(Distinct(Table1[DATE]), Distinct(Table2[OPERATION]))
or
gerenerate(Distinct(Table1[DATE]), Distinct(Table2[OPERATION]))
@Anonymous , Based on what I got
Crossjoin(Distinct(Table1[DATE]), Distinct(Table2[OPERATION]))
or
gerenerate(Distinct(Table1[DATE]), Distinct(Table2[OPERATION]))
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.