Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
4 years ago

REMAINS OF ACCUMULATED VALUES

Hello! my name is Karen! and I need the support of a DAX formula that allows me to calculate the subtraction of accumulated values per month, making one cut per year. In conclusion I want to get the result of the last column of the table. I will appreciate the support! 🙂

b33e23f3-78cd-4995-9645-8016ada714e3.png

 

2 Replies

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    4 years ago

    Please provide sanitized sample data that fully covers your issue. Paste the data into a table in your post or use one of the file services. Please show the expected outcome.

  • V-lianl-msft's avatar
    V-lianl-msft
    Icon for Community Support rankCommunity Support
    4 years ago

    Hi Syndicate_Admin ,

     

    Based on the data you provide, it is difficult to understand the calculation logic. Please give some explanation of calculation logic based on your data


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