Forum Discussion
Solved
Creating a conditional sequence in power BI table
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,...
NitinReja , A new column like
countx(filter(Table, [Employee] = earlier([employee]) && [Address] = earlier([Address]) && [Date] <= earlier([Date])),[Employee])
In case dates are same , then add an index column in power bi and use that in place of date
NitinReja , A new column like
countx(filter(Table, [Employee] = earlier([employee]) && [Address] = earlier([Address]) && [Date] <= earlier([Date])),[Employee])
In case dates are same , then add an index column in power bi and use that in place of date