Forum Discussion

BenazirMohammad's avatar
BenazirMohammad
Helper I
6 years ago
Solved

CONDITIONAL JOIN

Hi, I am fairly new to this and was wondering if anyone can help with this. I am not sure how to do a conditional JOIN in DAX or power query.   Here is my SQL statement. Select t1.* ,t2.col4 ,t3....
Need Help
BenazirMohammad's avatar
BenazirMohammad
Helper I
6 years ago

 

Thanks so much . It will take me sometime to undestand this since I am just a beginner.

I have couple of other questions:

1) How do I go about using that new table to Join it to my FACT tables. My FACT  has Category_KEY.

2) Is my approach correct.  are there simpler ways to get similar results. I am open to changing data structure / model of my security table.

Table 1 has close to 500k records, Table 2 about 20k records and my FACT table could go over 2mil records.

 

 

Thanks