trend for count of active tickets till date for last 7 days

[Ramendra]

Can some-one please help me to know How to get below kind of ageing trend for open tickets.

Till date	Count of  tickets which are with active state  till date
01-05-2020	10
02-05-2020	9
03-05-2020	11
04-05-2020	8
05-05-2020	7
06-05-2020	2
07-05-2020	5

[amitchandak]

@Ramendra , Try a new column like

new column
var _A = sumx(filter(Table,[ID] =earlier[ID] && [Type] ="A"),[Amount])
var _B = sumx(filter(Table,[ID] =earlier[ID] && [Type] ="B"),[Amount])
return
if(isblank(_A) , blank(), _A+_B)

[Ramendra]

@amitchandak  Please find attached screenshot. I hope you can help to get this result in power Bi. I wanted to attach excel but there is no option for this.

[ryan_mayu · Accepted solution]

@Ramendra 

I am guessing that you want to count all ticket excluding state is closed.

count = COUNTX(FILTER(rawdata,rawdata[create]<=EARLIER(rawdata[create])&&rawdata[State]<>"closed"),rawdata[Ticket])

When you are creating a visual, you set count as average value.

[ryan_mayu]

@Ramendra 

Could you please share the screenshot of your sample data?

How to identify if the ticket is open?

[Ramendra]

@ryan,  Please find screenshot of sample data and expectations. I wanted to attach excel but I am not getting option.