Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello Experts,
Need help on this.
I have compare count unique customers based on their sales >0 after launch months onwards as summary have given below.
@Tanushree_Kapse @VahidDM @GregM @amitchandak - Please help me on this.
Thanks a ton in advance.
Hi @Anonymous ,
Please check my reply in your another post: Re: Need help on custom report - Microsoft Power BI Community.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous
Can you add more details about the calculation? how did you create the result table in Excel? can you share the Excel formula?
Appreciate your Kudos!!
Hi,
Thanks for reply.
Actually , I have to count distinct of customer code from launch month to last months but we have to check sales >0 every month at customer level total sales
For example.
customore abc is purchased in launch month jan21 but not purchased in feb21 and again purchased in last month- hence then unique count will be 1 but it purchased 2 times.
Summary will be like abc customer is in north zone then
Zone launch month purchase 2 times purchase 3 times purchase >3 times
North 0 1 0 0
I Hope it will help
@VahidDM @Tanushree_Kapse @amitchandak @Greg_Deckler
Thanks.
@Anonymous
If abc is purchased in launch month jan21 why in the result table launch month purchase is Zero?
Zone launch month purchase 2 times purchase 3 times purchase >3 times
North 0 1 0 0
Appreciate your Kudos!!
Sorry type error, It should count 1 in launch month as well as in 2 times purchase column.
Thanks.
Zone launch month purchase 2 times purchase 3 times purchase >3 times
North 1 1 0 0
@Anonymous
Can you change your data structure? Unpivot all month columns.
Appreciate your Kudos!!
Hi,
I have done 90% of work by help of summarize funtion.
but one point on which I am stucking is that for example
Customer | Sales | Month | |
abc1 | 2202 | Jan-21 | |
abc2 | 1043 | Jan-21 | |
abc3 | 1576 | Jan-21 | |
abc1 | 0 | Feb-21 | |
abc2 | 1211 | Feb-21 | |
abc3 | 2989 | Feb-21 | |
abc1 | 1209 | Mar-21 | |
abc2 | 0 | Mar-21 | |
abc3 | 2036 | Mar-21 | |
abc4 | 1279 | Mar-21 | |
abc1 | 2258 | Apr-21 | |
abc2 | 0 | Apr-21 | |
abc3 | 320 | Apr-21 | |
abc4 | 2050 | Apr-21 | |
Summary will be | |||
Retention customer Count | |||
Measure | Feb-21 | Mar-21 | Apr-21 |
Unique Cust count | 2 | 2 | 3 |
** Retention means customers who have purchased at leat 1 time in any previous month.
I am not able to compare the customer wise sales in all previous months to get this result.
Please help me on this.
Thanks
@amitchandak @Greg_Deckler @Tanushree_Kapse @AlexisOlson @Jihwan_Kim @PBICommunity
Hi,
Data is in row level (inpivot). I had given the sample data set which i use in excel for working.
Thanks.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
47 | |
24 | |
20 | |
15 | |
13 |
User | Count |
---|---|
55 | |
48 | |
43 | |
19 | |
19 |