new line for each sales manager

[Anonymous]

Hello Community 🙂

Need help about a subject.

Table Calendar create with calendar(datea,datec)

date a

date b

date c

Table Sales : table comes from webservice (API)

John

Marc

Jane

I have a calendar from date A to Date B

I want to create for each day a line for each sales manger in order ti calculate turnover / .... by sales manger afterwards.

Results wanted : 

date a	John Marc Jane
date b	John Marc Jane
date c	John Marc Jane

thanks for your help. regards 🙂

NB : Don't hesitate proposing something for efficient if you know 🙂

[Anonymous]

I don't know why but after my last PowerBI update, my problem is solved, no more #ERROR.

The solution is the CROOSJOIN function.

Thanks to all of you !!!! 🙂

@v-yiruan-msft @Payeras_BI @amitchandak

[Anonymous]

hello, @amitchandak thanks for your answer 🙂

I don't think UNION answer my question because when I use UNION, the resutt is

date a

date b

date c

John

Marc

Jane

i need to create a line for each sales manager given by the table SalesManager (get by API) for each days created by calendar(datea,datec)

date a | John

date a | Marc

date a | Jane

date b | John

date b | Marc

date b | Jane

date c John

date c Marc

date c | Jane

thanks 🙂

have a good day

[Payeras_BI · Accepted solution]

Hello @Anonymous ,

Is not Union what has been suggested by @amitchandak but CrossJoin.

See below:

[Anonymous]

Sorry 

you are right.

do you know why I have this #ERROR

[Payeras_BI]

Hi @Anonymous ,

I believe you do not want to create a new column but a new table.

Instead of New column click on New table and use the same DAX code, the resulting table will be what you are looking for.

Regards,

J. Payeras

[Anonymous]

thanks it's exactly what I want 🙂

but I still have a mistake 😞

[v-yiruan-msft]

Hi @Anonymous ，

Does the sales table contain fields other than [sales] field? Does it also include the field named "Date"? If it also contains a field named Date, please rename the corresponding field and then cross join the table. Or you can try the method in the following thread:

Power Query Cross Join

Best Regards
Community Support Team _ Rena Ruan
If this post helps, then please consider Accept it as the solution to help the other members find it more.

[amitchandak]

@Anonymous , Do you want a cross join

crossjoin(Date, Sales) or use selectcolumns to select the columns you want

https://www.sqlbi.com/articles/from-sql-to-dax-joining-tables/