Wednesday, 17 February 2016

Identifying Customers Purchasing Behaviour Based on first Purchase(Whether it is small(or) Large)


Challenge:-
What type of customers is most likely to make repeat purchases – small first purchase or large first purchase?.

Solution:-

Create following 3 Calculated Fields:
          1.


2.


3.

Build the View:
1. First purchase bins on rows.
2. Multiple purchase? On columns.
3. Count distinct of customer name on columns.
4. Right click count distinct of customer name -> quick table calculation -> percent of total
    a.Make sure the compute using is table across.

prazval







Thanks Guru's,
Prazval.ks

DAX Time Intelligence Functions

   Thanks Guru's, Prazval.Ks