Creating a measure

[Anonymous]

I keep running into an issue. I have a table called customers and within that table I have a column called clien_since. Within client since are specific dates when each customer has become a customer. I tried to just add it to a date matrix but now I'm getting off set dates. The I tried to add it to a date hierarch line chart and just got a flat line. I'm not sure how to represent the client since data. Do I need to make a measure to join client since with the customer id column within the same table? If so how should I do that?

[Anonymous · Accepted solution]

Hi @Anonymous , Hello @Ashish_Mathur thank you for your prompt reply!

Based on your description, I create a table with two columns as shown below:

As you said, we can use a matrix to show the join date for each user like this:

 

We can also show the trend of users joining as shown below, if it shows a flat line, check if all users joined on different dates:

Please feel free to reply if your question still stands, or if I've missed something.

Best regards,

Joyce

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Ashish_Mathur]

Hi,

Share some data to work with and show the expected result.  Share data in a format that can be pasted in an MS Excel file.