Display New Customers list

[censoft17]

Hi,

I want to display a list of new customers within a particular date range.

For eg new customers list for July 2017

Output Template:

CustomerID || OrderID || FullName || EmailID || OrderDate || ProductName

Please provide a valuable solution.

[Eric_Zhang]

@censoft17

If the new customers means those who have the first order in the selected month, you can create a measure as below. See more in the attached pbix file.

isFirstOrder =
IF (
    CALCULATE (
        MIN ( yourTable[date] ),
        ALLEXCEPT ( yourTable, yourTable[customer] )
    )
        = MAX ( yourTable[date] ),
    1,
    BLANK ()
)

[bsas]

Hi,

Create slicer with month to select. it will show you list of customers depending on selected period.

[censoft17]

in Tableau, there is Fixed function , so the calculation i used to use was,

{FIXED CustomerID : min(Orderdate)} . [LOD Calculation]

How to use DAX calculation in power BI?

[bsas]

In PBI you can use filter on your visual and there indicate your needs.