Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
The subject does not really express well what I am looking for so I will be more thorough here. I have a table that I created on Edit Query (Date table) and another categorical table (Grade in my case).
NOTE: the two tables are unrelated, hence they have no column in common.
What I need to do is, "merge/combine" them in such a way that each date is repeated for every category:
Date table
Solved! Go to Solution.
@Nikochi -
In Power Query, you can do the following:
1. With your Date table selected, add a Custom Column. The formula will be = GradeTable.
2. Expand the new column and select the Grade column.
Cheers!
Nathan
@Nikochi -
In Power Query, you can do the following:
1. With your Date table selected, add a Custom Column. The formula will be = GradeTable.
2. Expand the new column and select the Grade column.
Cheers!
Nathan
@Anonymous Thank you so much 🙂
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
104 | |
95 | |
80 | |
67 | |
62 |
User | Count |
---|---|
146 | |
110 | |
107 | |
86 | |
63 |