cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Cyberguy23 Frequent Visitor
Frequent Visitor

Re: Find first distinct value based on condition

You are geniuos! Thankyou for your help. Both formulas worked. 

Cyberguy23 Frequent Visitor
Frequent Visitor

Re: Find first distinct value based on condition

Livio, if you could help me with the last new column please. 

 

I need a column "FirstPeriodM1All" that is populated with a period number where M1 was first found per customer. The sample data will look like below.  The logic is similar that is in the "FirstPeriodM1" with the exception that all customer records are now populated with a corresponding period number (whole Number)

 

CustomerMethod PeriodFirstPeriodM1M1CustomerCombined MethodFirstPeriodM1All
C1M21 XM1 & M2 & M32
C1M12XXM1 & M2 & M32
C1M32 XM1 & M2 & M32
C1M13 XM1 & M2 & M32
C2M21  M1 & M2 & M3 & M4 
C2M32  M1 & M2 & M3 & M4 
C2M43  M1 & M2 & M3 & M4 
C3M12XXM1 &M3 & M42
C3M33 XM1 &M3 & M42
C3M44 XM1 &M3 & M42
Super User
Super User

Re: Find first distinct value based on condition

Hello @Cyberguy23

 

You just need to leverage the first formula I posed, and use only this part:

 

    CALCULATE(
        MIN( Table1[Period] ),
        ALLEXCEPT( Table1, Table1[Customer] ),
        Table1[Method] = "M1"
    )

 


 


Did I answer your question correctly? Mark my answer as a solution!


Proud to be a Datanaut!  

Highlighted
Cyberguy23 Frequent Visitor
Frequent Visitor

Re: Find first distinct value based on condition

Hi, this is great. Exactly what I need. Thanks for all your help.