Make Sharepoint list to be like an Excel file

[Anonymous]

Im buiding a dashboard for someone who would like it to look exactly like an excel spreadsheet and they just need a simple slider and a total column (and to be autoupdated),

However i had to transform the data to have the date column accross the top of the spread sheet see image, my questions are how do i 

Move some rows up and down.

Change some of the rows back to percentages

Add a total column 

Could anyone help?

[v-shex-msft · Accepted solution]

Hi @Anonymous ,

You can go to query editor and do unpivot columns on your fields to merge them to attribute and value. After these steps, you can simply calculate on transformed records.

Unpivot columns (Power Query)
BTW, you can't direct modify data model tables to custom records. You can consider to use union function to create a new table with original records and custom records.

NEW TABLE =
UNION (
    Table,
    UNION (
        ROW ( "Column", "ABC", "Column2", DATE ( 2018, 1, 1 ), "Column3", 123 ),
        ROW ( "Column", "A3C", "Column2", DATE ( 2018, 1, 2 ), "Column3", 223 ),
        ROW ( "Column", "AE", "Column2", DATE ( 2018, 1, 3 ), "Column3", 133 )
    )
)

Regards,

Xiaoxin Sheng