rocio

[rcister]

Hello.

I need help 

I have the following table 

the column Count represents is one because it represents each row of overnight stays. I need to sum the Count column and be able to filter by timeStamp. It is important that the dates are summarized
eg
timeStamp
04/21/2021 ---> result equals 5
04/30/2021 ---> result is equal to 10 (the top 5 plus the current 5)

Thanks!!!

[v-xulin-mstf · Accepted solution]

Hi @rcister,

You can create measure as:

Measure = 
CALCULATE(
    SUM（'Table'[Count],
    ALL('Table')
)

Then you can apply the date slicer.

Best Regards,
Link

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

[dkaushik]

Hi @rcister ,

Are you trying to do it in power bi or excel? If power bi, then create a measure like this:
Sum of Count = CALCULATE(SUM('Table'[Count])). Then create a table visual and put your timestamp and this measure in.

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

Thanks,

Dheeraj

[rcister]

the source is from a excel , but i'm working power bi, this table is related with a master calendar, with the relation bwt calendar[datekey] ( represent a key for one unique date) and table [datekey] ( represent the key for overnigth date)

[dkaushik]

Okay. Then, the above solution should work.