combine tables

3 Topics

Join 2 tables
Hello all, I created a DAX table in which I created 2 variables, with which I get the data from 2 different tables. I want to join these 2 tables in only one. I tried with UNION (but I don't have the same amount of columns in the 2 tables), et NATTURALLEFTOUTERJOIN (but it doesn't work). Could someone help please ? Here's my code below : T04_MDPF_CDC V2 = var MDPF71 = SELECTCOLUMNS( T03_SKU_Country_List, "Affaire Planning Mode", LOOKUPVALUE('02_Ref_Affaires'[Planning_mode],'02_Ref_Affaires'[CDC_Location],[CDC Code Destination],BLANK()), "Affaire Name", LOOKUPVALUE('02_Ref_Affaires'[Title],'02_Ref_Affaires'[CDC_Location],[CDC Code Destination],BLANK()), "Material Code", var SubGrpAgg = SUMMARIZE( FILTER( S08_Z632_MatTransferAgg, T03_SKU_Country_List[Material Code] = S08_Z632_MatTransferAgg[Material Code] ), [SubGrpAgg] ) RETURN SubGrpAgg ) var Launch_Intro_Table = SELECTCOLUMNS( FILTER( S01_Launch_Intro, (S01_Launch_Intro[Product Code] & S01_Launch_Intro[Network Entity Destination Code]) IN SELECTCOLUMNS(T03_SKU_Country_List, "Key_SKU_CDC", T03_SKU_Country_List[Key_SKU_CDC]) ), "Material Code", [Product Code], "Project Code", [Project Code], "Launch Intro Status", [Final Launch Intro Status], "LI_15M", [LI_15M], "One Shot", [One Shot], "Flag LI Futur", [Flag LI Futur], "LI Final Product IDC Availability", [Final Product IDC Availability], "LI Final IDC Closing Date", [Final IDC Closing Date] ) var FirstJoinTable = UNION( Launch_Intro_Table, MDPF71 ) RETURN FirstJoinTable
Solved
Raphael33
2 years ago Place DAX Commands and Tips
503Views
0likes
1Comment
How to connect these two tables according to month & hour?
HI, I'm trying to connect one fact table (consumption data by hour ) with another table with different labels according to month & hour. It's like: "My consumption of 01:00-02:00 PM must be classified according to mounth & hour. With the table 2 I can labelled It." May I make a Calendar (Dim table) & HOUR(Dim table)? Yours sincerely, TeraMaster.
Solved
TeraMaster
3 years ago Place DAX Commands and Tips
814Views
0likes
2Comments
Measure with values matching another table (no relationships)
Hello all, Could you please help me get this DAX formula working? ShipTest2 = CALCULATE([Shipments],FILTER(MTH_Table,MTH_Table[MTH]=VALUES(DATES[Month]))) I need to have the result in the first matrix the same as in the second matrix. I was not able to figure out how to separate the numbers for the first table into months - the column MTH in MTH_table has no relationship with Month in DATES table. The only way I was able to get this "working" was to create 12 separate measures for each month which is not very efficient, I'd say. Please don't get into why I ask this stupid question. 😄 I need to further include in the calculation another measure with another date table. I apologize if the solution is already here somewhere, I was not able to find it.
Solved
Tomfiki
4 years ago Place DAX Commands and Tips
4.8KViews
0likes
4Comments