Forum Discussion

guitardude333's avatar
guitardude333
Frequent Visitor
5 years ago

How to add range filter and take average across columns

In Power BI I have a table in a report (Lets call it table1):   Person Role A Cleaning B Cooking C Cleaning I have another table (table2) in the source data which looks like (Perso...
Need Help
guitardude333's avatar
guitardude333
Frequent Visitor
5 years ago

Fowmy 

 

Thanks for your reply.

While trying to unpivot columns I get the error 

 

"Column 'Person' in Table 'PersonTime' contains a duplicate value 'A' and this is not allowed for columns on the one side of a many-to-one relationship or for columns that are used as the primary key of a table.

 

This is probably because the column 'Person' is a primary key. I deleted the relationships of this table with other tables and was able to unpivot. How can I again make these relationships?

 

Also, I am not sure how to create a dynamic measure. How can I specify start and end date for this measure and take the average of the values in between (for each person)?

 

Could you please tell me the steps? Sorry for my ignorance, I am new to Power BI.

 

Thank you