Creating a new Table based on data from another table using DAX

Question

Hello Community,&nbsp;I have loaded in a table-1 Containg the following&nbsp;I need to have the data formated as below in another table..&nbsp;Average Time Spent&nbsp;Time Spent in Room AxxxTime Spent in Room BxxxTime Spent in Room CxxxTime Spent in Room DxxxTime Spent in Room ExxxTime Spent in Eventxxx&nbsp;But when I calculate the Average .. I want to eliminate all "0" and the calculate Average..is there a possible solution for this?&nbsp;Thanks

anonymous · Accepted Answer

Used Unpivot columns option.. Thanks

	Average Time Spent
Time Spent in Room A	xxx
Time Spent in Room B	xxx
Time Spent in Room C	xxx
Time Spent in Room D	xxx
Time Spent in Room E	xxx
Time Spent in Event	xxx

Forum Discussion

Creating a new Table based on data from another table using DAX

1 Reply

Related content

Create new table

Lakehouse Table Generate Create Table

Column created in a table appears in another table

Create table from another table with conditions

Create rows from 2 tables