Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi everyone,
I'm trying to creat a dax table that can join two tables filtering the ICM column <> "Normal" in both tables.
Thank you so much
Pedro
Solved! Go to Solution.
@Anonymous
Something like
union (
summarize(filter(Table1,Table1[column5]= "Normal"),Table1[column1],Table1[column2],Table1[column3],Table1[column4]),
summarize(filter(Table2,Table2[column5]= "Normal"),Table2[column1],Table2[column2],Table2[column3],Table2[column4])
summarize(filter(Table3,Table3[column5]= "Normal"),Table3[column1],Table3[column2],Table3[column3],Table3[column4])
)
Also refer
https://radacad.com/append-vs-merge-in-power-bi-and-power-query
The information you have provided is not making the problem clear to me. Can you please explain with an example.
Appreciate your Kudos.
@amitchandak
Sure i can.
Instead of duplicating a couple of queries, and filter both by a certain column = "normal" and then append them, is it possible that, through dax i can make that table?
Thanks
Few ways
Selectcolumns
new Table = selectcolumns(table,"Col1", table[Col1], "COl2", Table[Col2])
Basically like a view now grouping , rename columns
new table =summarize(table,table[Col1], "COl2",sum( Table[Col2]))
Group by do not rename , Aggergated column have to rename
Table1 =Table //referance table
Table1 = distinct(Table) //new Table
Table1 = distinct(Table[Column]) //Distinct of column
There are a few more
@amitchandak Thank you!
I'm sorry to insist but (although i don't understand dax) i don't see in the instructions the join or the append between those tables.
Let's suppose i have table1, table2 and table3. All 3 tables, i just want all records with column1, column2, column3 and column4, regarding column5 = "Normal". These column5 exists in every table
I thank you very much for your patience
@Anonymous
Something like
union (
summarize(filter(Table1,Table1[column5]= "Normal"),Table1[column1],Table1[column2],Table1[column3],Table1[column4]),
summarize(filter(Table2,Table2[column5]= "Normal"),Table2[column1],Table2[column2],Table2[column3],Table2[column4])
summarize(filter(Table3,Table3[column5]= "Normal"),Table3[column1],Table3[column2],Table3[column3],Table3[column4])
)
Also refer
https://radacad.com/append-vs-merge-in-power-bi-and-power-query
@amitchandak you're the boss
Such a simple instruction!
Awesome. Thank you so much.
for append
union (
summarize(Table,Table[Col1],"Measure1",[Measure1]),
summarize(Table2,Table2[Col1],"Measure2",[Measure2])
summarize(Table3,Table3[Col1],"Measure3",[Measure3])
summarize(Table4,Table4[Col1],"Measure4",[Measure4])
)
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
116 | |
102 | |
78 | |
77 | |
49 |
User | Count |
---|---|
145 | |
108 | |
107 | |
89 | |
61 |