Forum Discussion
Customer Status Calculation
It's recommended to use a variable instead of the EARLIER function.
Also, for the variable first_date, you could create a separate table (using DAX or M) that has two columns: Customer ID, and First Date. Create a relationship between this table and the fact table, and use the RELATED function to retrieve First Date. This should be faster than calculating First Date for each row in the fact table.
It's recommended to use a variable instead of the EARLIER function.
Also, for the variable first_date, you could create a separate table (using DAX or M) that has two columns: Customer ID, and First Date. Create a relationship between this table and the fact table, and use the RELATED function to retrieve First Date. This should be faster than calculating First Date for each row in the fact table.
Hey, I created a seperate table the other day with ID and year and it worked perfectly. Thank you replying!
Glad to hear that!
