Running total to date

Hi AjithTravvise 

If the date increases daily, you could create calculated columns below:

earlier =
CALCULATE (
    SUM ( 'Table'[Running Value] ),
    FILTER (
        'Table',
        'Table'[Country]
            = EARLIER ( 'Table'[Country] )
            && 'Table'[Date]
                = EARLIER ( 'Table'[Date] ) - 1
    )
)

daily total = [Running Value]-[earlier]

As tested, if i understand you correctly, your second visual has some wrong data due to teh calculation rule.

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Thank you so much, it work out to perfection. 

Hi AjithTravvise 

check my pbix

Best Regards

Maggie

Hi AjithTravvise 

This solution was created using Power Query as you have posted your question in PQ section, the script dose Include the M code in Added Column step of the script.