Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
Hi there,
What I need is a basic date table with some extra items.
In 1 table I have a calender from Power BI with Year and Month (multiple years, all months per year).
In the other table I have one column with a lot of items, for example a, b, c, etc.
I need to combine these two tables so that all items repeat for every month in every year.
For example:
2020 january a
2020 january b
2020 january c
2020 february a
2020 february b
2020 february c
etc.
Thanks for your help.
@Mengeltje ,In Edit query mode
https://radacad.com/append-vs-merge-in-power-bi-and-power-query
In DAX you have crossjoin
new table = Crossjoin(Table1,Table2)
new table = filter(Crossjoin(Table1,Table2), table1[A]= table2[A])
In case you join between two tables you can use summarize, calculatetable
Without seeing your tables I'm not 100% this will work, but you could try editing your query in the editor (Click transform data in the top ribbon in the desktop). Try merging the tables using a full outer join which should create a table with every item assigned to every item. If that doesn't work could you post some sample data, and I can take a look.
User | Count |
---|---|
81 | |
75 | |
64 | |
45 | |
44 |
User | Count |
---|---|
103 | |
44 | |
39 | |
39 | |
37 |