Tag date start from historical data

Question

Hi,&nbsp;I need to be able to tag Customer IDs with respect to the month - year it started from historical data. Data is like panel data. Same customer in different points in time.&nbsp;&nbsp;Data:IDEffective Date1Sep-211Oct-211Nov-211Dec-211Jan-222Feb-202Mar-202Apr-202May-20

dimamd · Answer

Hi&nbsp;Anonymous&nbsp;Is this your desired outcome?Or you can use such a measure&nbsp;
&nbsp;
COMBINEVALUES("-",'table'[ID],'table'[Effective Date])
&nbsp;

anonymous · Answer

My desired outcome is:&nbsp;New Column which has will be tagged as New at the start of the effective date, everything else Existing.&nbsp;

dimamd · Answer

Anonymous&nbsp;Give an example of your desired outcome

dimamd · Answer

Anonymous&nbsp;If I understood you correctly, use the following measure.1. Add a column with Year2.&nbsp;Add a calculated column
&nbsp;
test = 
VAR mindata = MINX( FILTER('table', 'table'[ID] = EARLIER([id]) &amp;&amp; 'table'[Year] = EARLIER('table'[Year])),[Effective Date])
return
SWITCH(
     TRUE(),
     mindata = [Effective Date], "New"
     , "Existing")
&nbsp;

v-xiaotang · Answer

Hi&nbsp;Anonymous&nbsp;
Thanks for reaching out to us.
I just want to confirm if you resolved this issue? If yes,&nbsp;you can accept the answer helpful as the solution&nbsp;or&nbsp;share you method and accept it as solution, thanks for your contribution to improve Power BI.
If you need more help, please let me know.
&nbsp;
Best Regards,
Community Support Team _Tang
If this post&nbsp;helps, please consider&nbsp;Accept it as the solution&nbsp;to help the other members find it more quickly.

Forum Discussion

Tag date start from historical data

7 Replies

Related content

Visualizing Historical Data

Generate a column for dates between start dates (list/ pivot?)

Between date filter with fixed start date and latest end date

Historical Log support

User Group Leader Get Started Guide

ID	Effective Date
1	Sep-21
1	Oct-21
1	Nov-21
1	Dec-21
1	Jan-22
2	Feb-20
2	Mar-20
2	Apr-20
2	May-20