combine tables

5 Topics

Schedule refresh failed with Table.Combine
Hi all, I have created a new table using the function =Table.Combine({BI_fact_aaa_deals, BI_fact_bbb}) The 2 tables are from the same datasource and they have the same fields. I don't want to do a union all in sql statment beacouse the original views are used also for other direct queries If I remove the refresh flag on power query table properties it works correctly but data into reports are not updates Can you help me,please? Thanks
Solved
Giu
2 years ago Place Report Server
900Views
0likes
1Comment
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 retrieve specific column value from different table
Hello experts - I need help in power bi to combine 2 tables in a way to populate a specific column value from different table. I've 2 tables: MF table gets data from one source and ETL table gets data from another source. In MF table, I need to populate start or end time from etl table for jobs listed in a row. Please see below image.
AbrahamNaveed
2 years ago Place Desktop
716Views
0likes
2Comments
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