My running total resets, i have no idea why.

[Nickstad]

Hey, 

I'm new to PowerBi and i just cant seem to get my line graph right. For some reason the count keeps resetting. I would really appreciate some help with this. I posted some screenshots for clarification. Thank you!

[Nickstad]

Thanks for the replies @Syndicate_Admin @Thomas_Daubert , im working on it. Do you guys know if this date format is allright? I just can't seem to get the calender icon that i see when i look in tutorials online. 

 I got the DAX for the data from a friend.

[Thomas_Daubert]

Hello,

YTD is year to date, so it calculate from 1 january to 31 december and reset the 31 December at midnight.

you need something like that : 

Running Total COLUMN =
CALCULATE (
    SUM ( 'All Web Site Data (2)'[UniquePageviews] ),
    ALL ( 'All Web Site Data (2)' ),
    'All Web Site Data (2)'[Date] <= EARLIER ( 'All Web Site Data (2)'[Date] )
)

[Syndicate_Admin]

It looks like the issue you're experiencing with your line chart in Power BI is related to the way the data is being aggregated.

Based on the screenshots you've provided, it seems that the data is being aggregated by the "Date" column, and the "Count" column is being used as the value. However, the count is resetting every time the date changes, resulting in a line chart that starts at 0 for each new date.

To fix this, you need to change the way the data is being aggregated. One option is to group the data by the "Date" column and then use the "SUM" aggregation for the "Count" column. This way, the count will not reset every time the date changes, and the line chart will show the correct values.

Another option is to use the "COUNTA" function instead of "COUNT" function.

You can also use the "RUNNING_SUM" function to create a cumulative sum of the count, this way the count will not reset every time the date changes

You may also want to check if you have the correct date format in your data, this can also cause the issue.