Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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 |
| |||
date b |
| |||
date c |
|
thanks for your help. regards 🙂
NB : Don't hesitate proposing something for efficient if you know 🙂
Solved! Go to Solution.
Hello @Anonymous ,
Is not Union what has been suggested by @amitchandak but CrossJoin.
See below:
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 !!!! 🙂
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
Hello @Anonymous ,
Is not Union what has been suggested by @amitchandak but CrossJoin.
See below:
Sorry
you are right.
do you know why I have this #ERROR
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
thanks it's exactly what I want 🙂
but I still have a mistake 😞
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:
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.
@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/
User | Count |
---|---|
132 | |
74 | |
70 | |
58 | |
54 |
User | Count |
---|---|
192 | |
96 | |
67 | |
64 | |
54 |