topic Re: Column Refers to column in same table in DAX Commands and Tips

Column Refers to column in same table

antlufc — Wed, 28 Sep 2022 07:50:35 GMT

Hi All,

I have attached a Power Bi data tabel with the fileds i have to try and get to the expected result as per below.

I would like a DAX column that finds the Transaction type that refers to the SubscriptionVersion 1 based upon the customer reference. I would like this result to be in ever row in the new column expected result below:

https://1drv.ms/u/s!AivZWzcfJJzngR4sM0fFXflWaQAx?e=IIoRQk

Re: Column Refers to column in same table

tamerj1 — Wed, 28 Sep 2022 12:48:29 GMT

HI antlufc
Please refer to attached sample file with the solution

Required Result = VAR CurrentCustomerTable = CALCULATETABLE ( First_Transaction_Type, ALLEXCEPT ( First_Transaction_Type, First_Transaction_Type[Customer Reference] ) ) VAR FirstVersion = MINX ( CurrentCustomerTable, First_Transaction_Type[SubscriptionVersion Number] ) RETURN MAXX ( FILTER ( CurrentCustomerTable, First_Transaction_Type[SubscriptionVersion Number] = FirstVersion ), First_Transaction_Type[Transaction type] )

Re: Column Refers to column in same table

antlufc — Wed, 28 Sep 2022 14:44:21 GMT

Superb, worked perfectly.