Dip in the Count

[Chandrashekar]

Hello, 

Can you please help me with dax/column for where it shows dip in count of tickets.

In this example Company(AAB found in Jan-24 & Feb-24) and repeated once i.e Jan-24 & Feb-24. 

However not found in the month Mar to May. I need to display dip in the count. 

Link: Folder 

Regards,

Chandrashekar B

[Anonymous]

Hi @Chandrashekar ,
Thanks for @ThxAlot  effort.
Based on your description, I can understand that you want to highlight the process of increasing and decreasing.To help you further please provide the results you want to target in the form of a screenshot or excel.

Best regards,
Albert He

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

[Chandrashekar]

Hello,

I got dax what am looking for and it is working fine.

I have one more question on the same. May I know how get avegare for the same. For Ex: average(last N month/last N month-1). if am wrong in calculating avegare correct me.

Link: Folder 

DAX:

comparison =

var min_count=[min_count1]

var max_count=[max_count1]

var company = SELECTEDVALUE(Sheet1[Company])

return

if([min_count1] = [max_count1],"Observed Consistence in count",

if([min_count1] <= [max_count1],

"Client " & company & " found Raise in Count " & min_count & " to " & max_count,

"Client " & company & " found Dip in Count " & min_count & " to " & max_count) )

[Anonymous · Accepted solution]

Hi @Chandrashekar ,
Glad to see you found a solution and shared it. Please create a new post if you have another problem. One answer to one post will make it quicker for others with similar problems to find the answer.

Best regards,
Albert He

[Chandrashekar]

Hello Albert,

Thanks for your help. I will open new post.

Regards,

Chandrashekar B

[Chandrashekar]

Hello,

Thank you for your reply. Here is the screen shot.

Link: Folder 

Regards,

Chandrashekar B

[Chandrashekar]

Hello,

Can we get output as below.

Regards,

Chandrashekar B

[ThxAlot]

[Chandrashekar]

Hello,

Thanks a lot. I need output in table format like and possible condtional format highlihting the row.

1. Client AAB found Dip in May from 1(Jan-24) to 0 (May-24)

2. Client ABC found rise in May from 1(Apr-24) to 5(May-24)

Regards,

Chandrashekar B

[Chandrashekar]

Hello,

Any help on the request?

Regards,

Chandrashekar B

[Chandrashekar]

Hello,

Can anyone help on the request.

Regards,

Chandrashekar B