Need Help

[Anonymous]

Hello, 

I am trying to find the last and the first transaction type of an active and deactive customer. An active customer is the one with blank end date while the deactive is with the  end date.

Summary : Trying to find first and last membership type of an active and deactive customer . 

Following is the sample table and I am trying to achieve "First transaction Type" and "Last Transaction Type"

[v-chuncz-msft · Accepted solution]

@Anonymous 

You may take a look at the posts below.

• https://community.powerbi.com/t5/Desktop/Card-Help/td-p/514770
• https://community.powerbi.com/t5/Desktop/Return-another-column-based-on-condition/td-p/773314