how to get the cumulative column with partition by

[oakfootballclub]

hi experts, I want to create a column to get the culumative value of each fiscal year, here is the sample data

the  last column is the expected result, do you have any solutions? Thank you.

[Kishore_KVN · Accepted solution]

Hello @oakfootballclub ,

Use ALLSELECTED DAX function which will fulfill your requirement of partition by. 

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

[Anonymous · Accepted solution]

Thanks @Kishore_KVN  for his prompt reply. I believe his reply is helpful to you.

Hi @oakfootballclub ,

I have an other method and create a sample data to help you with your problem.

Sample data:

1. Add an index column.

2.Add a new column.

RESULT = 
VAR _INDEX = 'Table'[Index]
VAR _FY = 'Table'[fy]
VAR _AMOUNT1 =
    CALCULATE (
        SUM ( 'Table'[amount] ),
        FILTER ( 'Table', 'Table'[fy] = _FY && 'Table'[Index] <= _INDEX )
    )
RETURN
    _AMOUNT1

Final output:

How to Get Your Question Answered Quickly - Microsoft Fabric Community

If it does not help, please provide more details with your desired out put and pbix file without privacy information.

Best Regards,

Ada Wang

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

[Kishore_KVN · Accepted solution]

Hello @oakfootballclub ,

Use ALLSELECTED DAX function which will fulfill your requirement of partition by. 

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