Cumulative total filter by day

[jenas6423]

Hi All,

I have a table of hourly production table and a line chart.

I would like to draw a line chart to show the cumulative total of 'Inc' & 'Act' of the one day with the selection of dates in my slicer.

I wrote my measure, but it won't reset after new day.

From the image below, on 11/8/2020 8AM the Incremental value should show 85 instead of (85+93 = 178) which is the cumulative total from previous day (10/8/2020 8AM). When it goes to new day, the cumulative should restart. 

Here is my measure:

Can anyone please help? Thank you.

Regards.

Jenas

[amitchandak]

@jenas6423 , if you want to reset on each day then, you need have something like

table[Date] = max(Table[Date])

or

table[Datetime].date = max(Table[Datetime].date)

or

table[Datetime].date = max(Table[Datetime]).date

[jenas6423]

Hi @amitchandak 

I have added date into the filter, but it still doesnt work. Can you advise. Thank you.

[amitchandak · Accepted solution]

@jenas6423 , You are using <= , means take date less than that to

Use =  means only for that day. That will force it reset on the day.

if did not work

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.