Forum Discussion

jayjani's avatar
jayjani
Icon for Helper I rankHelper I
7 years ago

Pulling 2 different values in a single column

I have a table as shown in the below image. I want to add a 5th column "Total", which pulls the latest quarter value for Owned HC and sum total for Owned Cost. Example, for the month July, it should pull Q3 value (495) for Owned HC and 53.32 for Owned Cost.

 

I found the code to pull latest Owned HC (that is

Latest Owned HC =
Var CurrMonth = [CMonth]
Var CurrQuarter = [CQuarter]
Return
CALCULATE(AVERAGE('DAC Unpivot'[Value]), 'DAC Unpivot'[Transfer Org] = "Owned HC", 'DAC Unpivot'[Month No] = CurrMonth, 'DAC Unpivot'[Quarters]= CurrQuarter))
 
However, I don't know how can I get the Latest Owned HC and Sum total of Owned Cost in the same column?

 

Need Help

1 Reply

  • v-frfei-msft's avatar
    v-frfei-msft
    Icon for Community Support rankCommunity Support
    7 years ago

    Hi jayjani ,

     

    kindly share your sample data and excepted result to me if you don't have any Confidential Information. Please upload your files to One Drive and share the link here.