Forum Discussion

AllanBerces's avatar
AllanBerces
Post Prodigy
1 year ago
Solved

Combine Sum per Row

Hi good day, Can someone help me on my table, is there a way to sum the two area per row   Asia Week1 + North Week 1 = Combine Week 1 DESIRED OUTPUT Thank you
Need Help
  • rajendraongole1's avatar
    rajendraongole1
    1 year ago

    Hi AllanBerces - please check this

     

     

    Actual Remaining =
    IF(
        Input[Area] = "Combine",
        VAR WeekNum = Input[Week No.]
        RETURN
            SUMX(
                FILTER(
                    Input,
                    Input[Area] IN {"Asia", "North"} && Input[Week No.] = WeekNum
                ),
                Input[Remaining]
            ),
        Input[Remaining]
    )
     

     

     

    Hope this would help

rajendraongole1's avatar
rajendraongole1
Super User
1 year ago

Hi AllanBerces - please check this

 

 

Actual Remaining =
IF(
    Input[Area] = "Combine",
    VAR WeekNum = Input[Week No.]
    RETURN
        SUMX(
            FILTER(
                Input,
                Input[Area] IN {"Asia", "North"} && Input[Week No.] = WeekNum
            ),
            Input[Remaining]
        ),
    Input[Remaining]
)
 

 

 

Hope this would help

AllanBerces's avatar
AllanBerces
Post Prodigy
1 year ago

Hi rajendraongole1 thank you very much for the reply, working perfectly