Power BI Exchange

Please login or click SIGN UP FOR FREE to create your PowerBIUG account to join this user group.
 View Only
  • 1.  Help on Table

    Bronze Contributor
    Posted Dec 09, 2022 06:25 AM
      |   view attached
    Hello,

    See attached excel for your reference.

    Not sure how this can be achieved in PBI table.

    I've 2 Status columns and 2 Description columns. Against each status column which says "No", I should get the below Output:

    For instance - when we select "No" from Status 1 column, we see there are 4 Descriptions in Description 1 column, so this 4 description should come get populated against Each Description headers

    Similarly - from Status 2 column, when "No" is selected, we have 2 Descriptions against this. So the 2 description should get updated against that specific column i.e. Description 2 column.

    In column no. 3, I've added the Description names of each Headers.
    I've around 10 Status and Description columns. Please advise, if there's a way to achieve this.

    Thanking you in advance.

    ------------------------------
    Prem Guru
    ------------------------------

    Attachment(s)



  • 2.  RE: Help on Table

    Posted Dec 09, 2022 07:29 AM
      |   view attached
    Hi Prem,

    You can do a dax calculation creating a table from this main table and combine it with union function. You can add as many status & description as you wish.



    ------------------------------
    Rd 3nidad
    Senior Finance Analyst
    ------------------------------

    Attachment(s)

    pbix
    Status.pbix   35 KB 1 version


  • 3.  RE: Help on Table

    Bronze Contributor
    Posted Dec 09, 2022 09:25 AM
    @Rd 3nidad,

    Thanks! this is working as expected.

    But is there a way we add multiple relationship between the Conso table and my Table?

    For e.g. - we added ModelName, Color, Status 1 columns to the Conso table. Same level of columns are in my actual Table. I was able to create only one relationship between ModelName (Conso Table) and ModelName (My Table)

    How can we add 2 more relationship between Color and Status 1 columns?

    ------------------------------
    Prem Guru
    ------------------------------