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.

Actually it should concatenate all the row values in date range and bring it on single record per ID.

Appreciate your help

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]

4 Replies

  • cengizhanarslan's avatar
    cengizhanarslan
    Icon for Super User rankSuper User
    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]
  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    5 months ago

    Hi,

    I cannot understand your requirement.  Share data in a format that can be pasted in an MS Excel file.  Show the expected result very cearly.

  • 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.