Forum Discussion

Simao_Coimbra's avatar
Simao_Coimbra
Frequent Visitor
6 years ago
Solved

Simple Cumulative Total with a measure

Hello  everyone, I need some help that I think will be quite simple, but I'm not getting it. I have a measure called "HF_Mes", that returns the average chilling hours per month. HF_Mes ...
Need Help
  • v-lionel-msft's avatar
    v-lionel-msft
    6 years ago

    Hi Simao_Coimbra ,

     

    Please refer to my sample.

    I have a table like this.

    Then I created a calculated column.

    // It's best to use [MonthNo], because [Month] is text type data, we can't sort it. 
Month = [Date].[MonthNo]

     Then I created a meaure.

    Cum = 
CALCULATE(
    [HF_Mes],
    FILTER(
        ALLSELECTED(Sheet1),
        Sheet1[Month] <= MAX(Sheet1[Month])
    )
)

     

    Best regards,
    Lionel Chen

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-lionel-msft's avatar
v-lionel-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi Simao_Coimbra ,

 

Please refer to my sample.

I have a table like this.

Then I created a calculated column.

// It's best to use [MonthNo], because [Month] is text type data, we can't sort it. 
Month = [Date].[MonthNo]

 Then I created a meaure.

Cum = 
CALCULATE(
    [HF_Mes],
    FILTER(
        ALLSELECTED(Sheet1),
        Sheet1[Month] <= MAX(Sheet1[Month])
    )
)

 

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.