Hey Good Mornin,
I am new to the BI world, however i am searching resolving my issue regarding to the querying of a condition which came across in my daily reports,
actually I have two different types of users
1. The executive who process the transactions
2. The customer who was triggered against the transactions
I have duplicate entries of the both Users simultaneously with different types of Transactions( example, first transactions was for Cancellation, second was again for cancellation, third one was initiating a Partial Refund, fourth one was giving some sort of extension in a plan - All the above transactions has an unique Transaction id) , now I have multiple types of combinations to show case the clients, ex:- th count of advisor who initiate Cancellation + Partial Refund + Extension etc.., But now I am not able to pull the count , Can anyone please help me in getting a solution for this. Which functions or what will be logic that i can use in power query to get those counts for different types of combinations for each executives
The good part is I got the count of split or combinations, by
running a pivot in excel( so that it will eliminate the duplicate values of the customer, by using if and nesting AND operator inside if I got the count, but if I want to take the count of the executive basis on the split I have to consider the customer also, there is the problem statement ?
