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 =...
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.

v-csrikanth's avatar
v-csrikanth
Icon for Community Support rankCommunity 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