Forum Discussion

vchauhan011's avatar
vchauhan011
Frequent Visitor
4 years ago
Solved

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

Replies have been turned off for this discussion