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. tabl...
Need Help
  • vchauhan011's avatar
    vchauhan011
    4 years ago

    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.