Forum Discussion

AtchayaP's avatar
AtchayaP
Helper V
4 years ago
Solved

Powerbi

 can I know how to use it?

  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi AtchayaP ,

     

    Here's the formula:

    both = 
    var tmp = SUMMARIZE('Table','Table'[name],'Table'[content type],'Table'[type])
    return
    CONCATENATEX(FILTER(tmp,[name]=EARLIER('Table'[name])),'Table'[type],"+")

     

    Best Regards,

    Jay

4 Replies

    • AtchayaP's avatar
      AtchayaP
      Helper V

      Can you tell me the full expression how to use it

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi AtchayaP ,

     

    Here's the formula:

    both = 
    var tmp = SUMMARIZE('Table','Table'[name],'Table'[content type],'Table'[type])
    return
    CONCATENATEX(FILTER(tmp,[name]=EARLIER('Table'[name])),'Table'[type],"+")

     

    Best Regards,

    Jay

  • Anonymous's avatar
    Anonymous
    Not applicable

    Power BI is an interactive data visualization software product developed by Microsoft with a primary focus on business intelligence. It is part of the Microsoft Power Platform.

     

    Greeting,

    Rachel Gomez