Forum Discussion

will1296's avatar
will1296
Frequent Visitor
8 years ago
Solved

Dividing rows

Hi,   Im new to power BI and am facing some problems here. I have a table like this:   CAMP TYPE ITEM UNITS 201701 A Apple 100 201702 B Lemon 50 201702 A Apple 1000  ...
Need Help
  • v-yulgu-msft's avatar
    v-yulgu-msft
    8 years ago

    Hi will1296,

     

    For BreakDown table, I changed its structure to make it more usable.

     

    In CAMP table, I added some auxilliary columns as highlighted in below image.

     

    Then, I make PreviousMonth, CurrentMonth and NextMonth records to be listed in a single column via UNION. And use LOOKUPVALUE function to refer to BreakDown value in BreakDown table.

     

    For more detailed steps, please see the attached .pbix file. CAMP Table_2 is the result table.

     

    Best regards,

    Yuliana Gu

v-yulgu-msft's avatar
v-yulgu-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi will1296,

A B
30% M1 90% N1
50% M2 10% N2
20% N2    

 

 

Please post the correct table structure of the breakdown index table. Show us column headers and detailed records.

 

Regards,

Yuliana Gu

will1296's avatar
will1296
Frequent Visitor
8 years ago

Hi v-yulgu-msft

Thanks for your notice :)