Creating a conditional sequence in power BI table

Question

Hi All,I am a new user to Power BI... transitioning from Excel.I have a table of visits done by our employees to certain addresses. However, in certain visits the items picked up are more than 1, hence, the number of rows are multiple if there are multiple item pickups in same visit. Each row represents one item.Our charging is based on pickup as well as item... for Eg, every visit - first item is charged as Rs 300 whereas 2nd item onwards on same visit is charged at Rs 150 per item.In excel, we could do this easily by combining, date-employee-adress to create a unique visit and then look at first row as item 1 and next similar rows as item 2... thereby allowing pricing (1 is charged at 300 whereas 2 is charged as 150). I have created Ref. Sequence column using IF formula with condition on column "Unique". How can I replicate somethint like this in Power BI?&nbsp;&nbsp;

amitchandak · Accepted Answer

NitinReja , A new column like
&nbsp;
countx(filter(Table, [Employee] = earlier([employee]) &amp;&amp; [Address] = earlier([Address]) &amp;&amp; [Date] &lt;= earlier([Date])),[Employee])
&nbsp;
In case dates are same , then add an index column in power bi and use that in place of date

Forum Discussion

Creating a conditional sequence in power BI table

2 Replies

Related content

Conditional Sequence

Create Sequence Number using DAX

Create conditional measure

Create conditional index column

Create a column with a repeating sequence