Forum Discussion

akkitek's avatar
akkitek
Icon for Helper III rankHelper III
4 years ago
Solved

Adding column with a replaced value

Hey Everyone, This seems like a very easy question. I have a table with few fields like "Resource type", "Resource Temporary Worker (Yes/No)", "Person Hours", "Utilization basis hours". I then creat...
Need Help
Show and Tell
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    4 years ago

    hi

    Measure = if(SELECTEDVALUE(FACT_Ops_Data_by_Wk[Resource Type])="Billable Employee",1,FACT_Ops_Data_by_Wk[Billable Utilization %])
     
    if this post helps, Accept this as solution
Anonymous's avatar
Anonymous
Not applicable
4 years ago

hi

Measure = if(SELECTEDVALUE(FACT_Ops_Data_by_Wk[Resource Type])="Billable Employee",1,FACT_Ops_Data_by_Wk[Billable Utilization %])
 
if this post helps, Accept this as solution
  • akkitek's avatar
    akkitek
    Icon for Helper III rankHelper III
    4 years ago

    This worked! Thank you so much!