Forum Discussion
Creating a table with dates and distinct customers
Hello Power Bi Community,
this is my first post so here goes.
I have a table of distinct customers..
Table 1:
Customers
Customer1
Customer2
Customer3
I want to create a table that looks like this
Date Customer
1/1/21 Customer1
1/1/21 Customer2
1/1/21 Customer3
2/1/21 Customer1
2/1/21 Customer2
2/1/21 Customer3
3/1/21 Customer1
3/1/21 Customer2
3/1/21 Customer3
...
thanks in advance
Hi, Anonymous
Please check the below.
New Table =CROSSJOIN(VALUES(Dates[Date]), VALUES(Customers[Customer]))Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.
Linkedin: linkedin.com/in/jihwankim1975/
Twitter: twitter.com/Jihwan_JHKIM
1 Reply
- Jihwan_KimSuper User
Hi, Anonymous
Please check the below.
New Table =CROSSJOIN(VALUES(Dates[Date]), VALUES(Customers[Customer]))Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.
Linkedin: linkedin.com/in/jihwankim1975/
Twitter: twitter.com/Jihwan_JHKIM