Forum Discussion
yoa380
Helper I
Helper IGet comments from another table in matrix
Hello, I have imported in my PBI model a table from Excel where people can put comments. This fact table 1 has column A = YearWeek in text / column B = Category of products in text / Column C = ...
Hi yoa380
I've tweaked your formula a little bit, and it seems to produce your required output.
I attach the pbix file as an example.
DataNinja777
Super User
Super UserHi yoa380 ,
You can get your required output by using ConcatenateX like below:
I am assuming that your 'Table 1' and 'Table 3' have relationship with the Calendar dimension table. In order to use the min function, you need to convert "2024W19" to numerical format like 2024.19.
Best regards,