Dax Function

[thobenjo1]

Hi Experts,

I have a query in the column 'balance due' and dates,2-3 years of data is there. So in power Bi I want to have running total with the current date, so when I refresh next month it automatically takes next month's date and refresh. 

Eg : 2018

            January

                          XYZ          5

                          XYW         10

                          XYZ         15

2019

            January

                          XYZ          5

                          XYW         10

                          XYZ         15

[wdx223_Daniel]

it's hard to achieve when there are duplicate values in the 3rd column.