Calculate customers visits frequency

[Anonymous]

Hi there,

I'm new to the forum and DAX and I need some help.

Generally, the problem is that I have a table with 2 fields, Dates and Customers. What do I want to get is a chart showing how many customers are visited 1 time, how many 2 times and etc. Link to the data is here: CustomersVisitsData

Thank you in advance.

[Zubair_Muhammad]

@Anonymous

If you already have a Count of Visits Column in your Raw Data

you can simply put it in the X - Axis and put the count of count of Visits as Values

Please see the attached file

If you dont have this column, you can use this calculated column

Count of Visits =
IF (
    [DATE_OF_VISIT]
        = MINX (
            FILTER ( Table1, [Customer Name] = EARLIER ( [Customer Name] ) ),
            [DATE_OF_VISIT]
        ),
    CALCULATE (
        COUNT ( Table1[DATE_OF_VISIT] ),
        ALLEXCEPT ( Table1, Table1[Customer Name] )
    )
)

[Zubair_Muhammad · Accepted solution]

@Anonymous

File attached here

[isynergy]

Hi Zubair,

How can I create a measure instead of inserting a new column? I tried to modify the code but it didn't work.

Thanks for your help in advance!

[Anonymous]

Thank you. That's great. Really appreciate you help.