Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello,
I have a new PBI challenge for myself, I new to create a table that duplicate distinct values from two tables. One column is calendar(date) (from calendar table), the second column is product(id) (from product table).
Below is an example of what I need.
Date | Product_ID |
01/01/2022 | 44 |
01/01/2022 | 45 |
02/01/2022 | 44 |
02/01/2022 | 45 |
I really don't know if it is possible to do it threw DAX.
Thanks a lot for your help,
Paul
Solved! Go to Solution.
Hi @PaulMGNT
if you are lioking for a calculated table then
CROSSJOIN ( VALUES ( 'Calendar'[Date] ), VALUES ( 'Product'[ID] ) )
Hi @PaulMGNT
if you are lioking for a calculated table then
CROSSJOIN ( VALUES ( 'Calendar'[Date] ), VALUES ( 'Product'[ID] ) )
Hi tamerj1,
this is great, thanks a lot.
Paul
Check out the July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
User | Count |
---|---|
18 | |
7 | |
7 | |
5 | |
5 |
User | Count |
---|---|
25 | |
10 | |
10 | |
9 | |
6 |