Forum Discussion

Hash2023's avatar
Hash2023
Frequent Visitor
2 years ago

Combine data from different tables with a filter

Hello Team,   I have 3 tables (ID, Transaction_Jour and Transaction_Code). I want to bring column "Extra_Purchase_Date" in Transaction_Jour to the table ID with the rules that it brings the first t...
General Comment
Need Help
Show and Tell
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Hash2023 ，

Below is my table1:

Below is my table2:

Below is my table3:

The following DAX might work for you:

Extra_Purchase_Date = 
   var pre_date = MIN(Tracsaction_Jour[Extra_Purchase_Date])
   return pre_date

The final output is shown in the following figure:

Best Regards,

Xianda Tang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hash2023's avatar
Hash2023
Frequent Visitor
2 years ago

Hi Anonymous ,

 

Thank you for your response and help. I appreciate your help on this matter.

 

The proposed idea unfortunately, does not seem to be working in my case. 😞

 

I pulled the Revenue Code from table 3 into table 1.

I have been trying and the statement below seems to be working:

 

CALCULATE(FIRSTNONBLANK(TransactionJournal[purchase_date],1),FILTER((TransactionJournal),'Id'[hotelregno_id]=TransactionJournal[hotelregno_id]))
 
However, I need to add the condition that: TransactionJournal[Extra_Type] = "Extras Revenue" which i haven't been able to so far. Any idea on how i can do it?

 

Many Thanks.

 

Kind Regards,