Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
Hello,
How to get first occurrence from duplicate based on multi conditions.
Regards,
Chandrashekar B
Hi,
I do not know what is your expected outcome and how your data model looks like, but I tried to create a sample like below.
Please check the below picture and the attahced pbix file.
It is for creating a new column.
First occurrence flag CC =
IF (
Data[Index]
= MINX (
FILTER ( Data, Data[Category] = EARLIER ( Data[Category] ) ),
Data[Index]
),
"FLAG"
)
Hello,
Thanks for the solution. However I need based on mutli condition(Attached)
File: Sample Data
Regards,
Chandrashekar B
Hello,
I want to add one more condition i.e. field(2nd Condition) = 1 to existing dax.
May I know how to do it.
Regards,
Chandrashekar B
Hello,
Can I add one more condition in Dax formula. i.e. field(2nd Condition) = 1
First occurrence flag CC = IF ( Data[Index] = MINX ( FILTER ( Data, Data[Category] = EARLIER ( Data[Category] ) ), Data[Index] ), "FLAG" )
Regards,
Chandrashekar B
Hello,
Any solution?
Regards,
Chandrashekar B
User | Count |
---|---|
13 | |
12 | |
8 | |
8 | |
6 |
User | Count |
---|---|
27 | |
19 | |
13 | |
11 | |
7 |