Forum Discussion

GoodMan85's avatar
GoodMan85
Frequent Visitor
1 year ago
Solved

Rolling SUM

I have a column in the table where it is the result of a conditional measure:

 

Act/TTO Backlog = [R Tot '25] + [D Mtly '25] + [Backlog 25]

 

The 3 measures are formed as follows:

 

R Tot '25 = IF(MAX(OINV_HH[ID Month]) = MONTH(TODAY()), 0, CALCULATE(SUM(INV1_HH[LineTotalSc]), YEAR(OINV_HH[DocDate]) = 2025) - CALCULATE(SUM(RIN1_HH[LineTotal]), YEAR(ORIN_HH[DocDate]) = 2025))

 

D Mtly '25 = CALCULATE(SUM(DLN1_HH[LineTotalSc]), YEAR(ODLN_HH[DocDate]) = 2025, MONTH(ODLN_HH[DocDate]) = MONTH(TODAY()))

 

Backlog 25 = IF(MAX(RDR1_HH[IDMonth_B]) = MONTH(TODAY()), CALCULATE(SUM(RDR1_HH[LineOpenSc]), YEAR(RDR1_HH[ShipDate]) = 2025, RDR1_HH[LineStatus] = “O”, RDR1_HH[U_CONF_LINE] = “Y”), CALCULATE(SUM(RDR1_HH[LineOpenSc]), YEAR(RDR1_HH[ShipDate]) = 2025, RDR1_HH[LineStatus] = “O”))

 

In the dashboard table, I cannot do a simple total but it repeats the measurement logics for me.

 


Could you please help me?

Need Help
  • pankajnamekar25's avatar
    pankajnamekar25
    1 year ago

    Hello GoodMan85 

     

    Use this measure

     

    Act/TTO Backlog Total =
    IF(
    HASONEVALUE('Calendar'[Month]),
    [Act/TTO Backlog], -- Return individual values for each month
    SUMX(
    VALUES('Calendar'[Month]),
    [R Tot '25'] + [D Mtly '25'] + [Backlog 25]
    )
    )

     

    Thanks,
    Pankaj

    If this solution helps, please accept it and give a kudos (Like), it would be greatly appreciated.

4 Replies

  • pankajnamekar25's avatar
    pankajnamekar25
    Super User
    1 year ago

    Hello GoodMan85 

     

    Use this measure

     

    Act/TTO Backlog Total =
    IF(
    HASONEVALUE('Calendar'[Month]),
    [Act/TTO Backlog], -- Return individual values for each month
    SUMX(
    VALUES('Calendar'[Month]),
    [R Tot '25'] + [D Mtly '25'] + [Backlog 25]
    )
    )

     

    Thanks,
    Pankaj

    If this solution helps, please accept it and give a kudos (Like), it would be greatly appreciated.

    • GoodMan85's avatar
      GoodMan85
      Frequent Visitor
      1 year ago

      Hi pankajnamekar25,

      thank you. It's work.

  • v-csrikanth's avatar
    v-csrikanth
    Community Support
    1 year ago

    Hi GoodMan85 

    Thank you for being part of the Microsoft Fabric Community.

    As highlighted by pankajnamekar25 @, the proposed approach appears to effectively address your requirements. Could you please confirm if your issue has been resolved
    If you are still facing any challenges, kindly provide further details, and we will be happy to assist you.

    Best Regards,
    Cheri Srikanth

  • v-csrikanth's avatar
    v-csrikanth
    Community Support
    1 year ago

    Hi GoodMan85 
    Thanks for confirming the issue was resolved.
    If yes, please Accept as Solution to help others benefit in the community. 

    Best Regards,
    Cheri Srikanth