Forum Discussion

H_insight's avatar
H_insight
Icon for Helper V rankHelper V
6 years ago
Solved

New and Recurring Customers

Hello, I have a sample data that contains 8 columns. What I am trying to do is to identify new customers withing the current reporting month, but my measure is not returning the right outcome.   N...
Need Help
  • H_insight's avatar
    H_insight
    6 years ago

    danextian 

     

    Thanks for your help on this. I have changed the OldSalesCount to:

    OldSalesCount = 
IF (
     EOMONTH(Data[Service Start],0) < EOMONTH(Data[Reporting Month],0),
    0,
    1
)

    and the result came as expected.

     

    Cheers

nhoward's avatar
nhoward
Icon for Resolver I rankResolver I
6 years ago

Hi Hesham,

 

We'll need to know the tables and relationships in your data model before we can help. 

H_insight's avatar
H_insight
Icon for Helper V rankHelper V
6 years ago

Hi nhoward ,

 

Here is the PBIX link & the sample file.

 

The sample file holds a simple model of Data (fact) and Date table. Only one relationship between Reporting Month in Data table & Date in Date table.

 

Please let me know if you require any additional information.

 

Thanks

Hesham