Forum Discussion

yoa380's avatar
yoa380
Icon for Helper I rankHelper I
2 years ago
Solved

Get 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 = ...
yoa380's avatar
yoa380
Icon for Helper I rankHelper I
2 years ago

thanks for quick reply, I don't really need to use my calendar table here as my table 3 (even if several lines) will always only have a single value for YearWeek. I thought using MIN was good idea because I can't just say "equals to YearWeek column".

It's just to make the filter on Table 1.

I tried your logic but I get an error message.

I also tried : 

Comments =
CONCATENATEX(FILTER(Table1,Table1[YearWeek]=MIN(Table3[YearWeek])),Table1[Comments])
It finds my values but it put them all stuck together, without taking into account the Category.
Example for CAT1 it will put = Nothing to declare Trials
  • DataNinja777's avatar
    DataNinja777
    Icon for Super User rankSuper User
    2 years ago

    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.