Forum Discussion
First Occurence : Multi Occurence
Hello,
How to get first occurence based on multi condition.
Condition: Column A & Column B & Column C
Expected result: Column D
PBIX: Sample File
Regards,
Chandrashekar B
2 Replies
Chandrashekar , You need to add an index column in power query and then addfollwing column in DAX
Column = if( minx(FILTER(Sheet1, [Number] = EARLIER(Sheet1[Number])),[index]) = [index],1,0)
Power Query- Index Column: https://youtu.be/NS4esnCDqVw
Hello Amit,
May I know how it is working as formula need to consider condition Column B & Column C as well.
Regards,
Chandrashekar B
Regards,
Chandrashekar B
