Forum Discussion
Convert Column values into Rows using DAX
Hello,
I need to convert data from one of my columns to new columns. I have two tables A and B. Table A is a measure table which has Total hours, billable hours, non billable hours measures. table B looks similar to the table in the screenshot below. Both These table are part of Power BI Dataset so I am not able to edit them into power query.
I want my end result as below table. Staff name field is from different table from the same PBI dataset. Total hours, Billable hours and Non Billable hours fields are measures from the measures table
Is this something possible to do?
Thank you very much in advance for your help.
Hi,
I was able to figure out a way to solve the issue I was having. I used the below formula to create new measures.
Leave = Calculate([Total Hours],'Table name'[Code Description] = "Leave")Thanks.
2 Replies
- amitchandakSuper User
vchauhan011 , to me this seem like a hybrid table
if you are looking for a Hybrid display with Matrix Column and measure
https://community.powerbi.com/t5/Community-Blog/Creating-a-custom-or-hybrid-matrix-in-PowerBI/ba-p/1354591
https://community.powerbi.com/t5/Quick-Measures-Gallery/The-New-Hotness-Custom-Matrix-Hierarchy/m-p/963588#M428vote for Hybrid Table
https://ideas.powerbi.com/ideas/idea/?ideaid=9bc32b23-1eb1-4e74-8b34-349887b37ebc - vchauhan011Frequent Visitor
Hi,
I was able to figure out a way to solve the issue I was having. I used the below formula to create new measures.
Leave = Calculate([Total Hours],'Table name'[Code Description] = "Leave")Thanks.