Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Minimum Purchase Date for a Customer

Hi,   I am trying to find the First Purchase Date for the customers. So in the screenshot below, for this customer First Purchase Date is 4th Sep, but when I add Month Year to the table, the First...
Need Help
  • MohammadLoran25's avatar
    MohammadLoran25
    3 years ago

    Hi,

    Create a calculated column in your Customer Dimension as below:

     

    CALCULATE (
        MIN ( 'Date Table'[DateColumn] ),
        RELATEDTABLE ( 'Pucrchase Fact Table' )
    )

    Then your problem would be solved.

     

    Best Regards.

MohammadLoran25's avatar
MohammadLoran25
Solution Sage
3 years ago

Hi,

Create a calculated column in your Customer Dimension as below:

 

CALCULATE (
    MIN ( 'Date Table'[DateColumn] ),
    RELATEDTABLE ( 'Pucrchase Fact Table' )
)

Then your problem would be solved.

 

Best Regards.