Forum Discussion

sarthsla's avatar
sarthsla
Frequent Visitor
5 months ago
Solved

Concatenating row values based on date selection in 1 record

Hi All, I have below data , where main data is o/p of query in Table Visual. Now when I select filter on Report Date it should show data accordingly in the snap shot below given in 2 cases. ...
Need Help
  • cengizhanarslan's avatar
    cengizhanarslan
    5 months ago

    Step 1) Create concatenation measures

    Currency List =
CONCATENATEX(
    VALUES ( MainData[Currency] ),
    MainData[Currency],
    ", "
)

CcY Sets List =
CONCATENATEX(
    VALUES ( MainData[CcY Sets] ),
    MainData[CcY Sets],
    ", "
)

Tenor List =
CONCATENATEX(
    VALUES ( MainData[Tenor] ),
    MainData[Tenor],
    ", "
)

     

    Step 2) Build the table visual

    Put in the visual:

    • ID
    • [Tenor List]
    • [Currency List]
    • [CcY Sets List]
Anonymous's avatar
Anonymous
Not applicable
5 months ago

Hi sarthsla 

Thank you for reaching out to the Microsoft Fabric Forum Community.

Ashish_Mathur cengizhanarslan Thanks for the inputs.

I hope the information provided by users was helpful. If you still have questions, please don't hesitate to reach out to the community.

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 months ago

    Hi  sarthsla 

    Hope everything’s going smoothly on your end. I wanted to check if the issue got sorted. if you have any other issues please reach community.