Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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
@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
User | Count |
---|---|
20 | |
18 | |
15 | |
11 | |
7 |
User | Count |
---|---|
28 | |
27 | |
13 | |
12 | |
12 |