Forum Discussion
DAX function - Index and match
9036273024 , For second table when uploaded to powerBI will convert the first row that contains service names to column headers. So there will be two tables in PowerBI
1. Table with doctor name and services they provide two columns.
2. With doctor name and columns with header name being services[s1, s2, s3, etc. being columns].
To change the second from happening, go to powerQuery[transform data] and select every column except doctor name and unpivot the table.
Now, in matrix visual rows can be doctors name, columns can be the new column that contains every service and values can be price.
This will create a matrix visual of a doctor and service name.
Thank You.
Solution Sage9036273024 , For second table when uploaded to powerBI will convert the first row that contains service names to column headers. So there will be two tables in PowerBI
1. Table with doctor name and services they provide two columns.
2. With doctor name and columns with header name being services[s1, s2, s3, etc. being columns].
To change the second from happening, go to powerQuery[transform data] and select every column except doctor name and unpivot the table.
Now, in matrix visual rows can be doctors name, columns can be the new column that contains every service and values can be price.
This will create a matrix visual of a doctor and service name.
Thank You.