Forum Discussion
table into list
I have the first 4 columns of the table in the image below (until [PLACEMENT]). I want to add the other two columns on the right.
The first one lists all products that have a promo in the same period, while the other one lists all products that have a placement.
Thanks
@jorgeslzr
Are you going over the question or is it the same as the one below?________________________
If my answer was helpful, consider Accepting it as the solution to help other members find it
Click the Thumbs-Up icon if you like this answer 🙂
3 Replies
jorgeslzr , Try
column for all in promo = concatenatex(filter(Table, [Promo Title] = earlier( [Promo Title] ) ),[Product] )
column for all in Placement = concatenatex(filter(Table, [Placement] = earlier( [Placement] ) ),[Product] )@jorgeslzr
Are you going over the question or is it the same as the one below?________________________
If my answer was helpful, consider Accepting it as the solution to help other members find it
Click the Thumbs-Up icon if you like this answer 🙂
jorgeslzr - You can do this like the following:
All in Promo Column = VAR __Period = [PERIOD] RETURN CONCATENATEX(FILTER('Table',[PERIOD]=__Period),[PRODUCT],",") All in Placement Column = CONCATENATEX(FILTER('Table',[PLACEMENT]=1),[PRODUCT],",") All in Promo Measure = VAR __Period = MAX([PERIOD]) RETURN CONCATENATEX(FILTER(ALL('Table'),[PERIOD]=__Period),[PRODUCT],",") All in Placement Measure = CONCATENATEX(FILTER(ALL('Table'),[PLACEMENT]=1),[PRODUCT],",")
