Create a End date column based on Created date column

Question

Hello everyone,I have a Created date column in my Power BI data. Now, I need a formula that will&nbsp;create an&nbsp;End date column that filters per Code and shows the Created date value of next row if not balnk. Example shown below.&nbsp;&nbsp;

rohit11 · Accepted Answer

Try this !&nbsp;&nbsp;End = MINX (&nbsp; &nbsp; FILTER (&nbsp; &nbsp; &nbsp; &nbsp; 'Table',&nbsp; &nbsp; &nbsp; &nbsp; 'Table'[Create] &gt; EARLIER ( &nbsp; 'Table'[Create] &nbsp;)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &amp;&amp; 'Table'[Code] = EARLIER ( 'Table'[Code] )&nbsp; &nbsp; ),&nbsp; &nbsp; &nbsp;'Table'[Create])&nbsp;Mark as ansered if it solved your problem .&nbsp;&nbsp;

Forum Discussion

Create a End date column based on Created date column

1 Reply

Related content

Create columns group

Creating ICMs via Activator

Creating relationships

Create new table

Fabric Create report API