Forum Discussion

Voose's avatar
Voose
Icon for Helper III rankHelper III
9 years ago
Solved

Bring one total column from a table into another

Hi Guys,   Feel like I have a basic question here but just unsure how I can get this done in my head. In one table i have my target utilisation by region and by Month:   Target Utilisation Re...
Need Help
  • MFelix's avatar
    MFelix
    9 years ago

    Hi Voose,

     

    Try to make a ID column in each of the table composed by region and month, them do a relation between the two table with that ID and you can the make a Column or use the values from the two table directly.

     

    the Column will look something like this 

    Column = CALCULATE(SUM(Target[Target Utilisation]);RELATEDTABLE(Target))

    Regards

     

    MFelix 

Voose's avatar
Voose
Icon for Helper III rankHelper III
9 years ago

Hi MFelix,

 

So I want Days worked to be a % of Total working days by month for exmaple in this picture you can see that April is about 80% and in June its around 40%, I could like to see that on a single line graph,

 

 

Does that make sense? I shouldn't have 2 values on the graph, just 1 and that 1 value should be the % of these two against each other

 

Thanks

 

Voose

MFelix's avatar
MFelix
Icon for Super User rankSuper User
9 years ago
Voose,

Makes sense but that is different make a column that divides total days worked by total working days then format as % and use it in your chart.

Mfelix