Forum Discussion

Bruce_Fei's avatar
Bruce_Fei
Regular Visitor
5 years ago
Solved

summarize a table

Hello    I have a  source table like below objects process mat serial_number ob_dz datetime date week_no Month XTA   Process1 mat1 S1 1 8/13/2020 5:53:36 PM 8/13/2020 12:00:00 ...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    Bruce_Fei , Summarize will remove duplicate try like

    SUMMARIZE(Sheet1,Sheet1[objects],Sheet1[Month],Sheet1[mat],"totalBuild",COUNT(Sheet1[mat]))

amitchandak's avatar
amitchandak
Super User
5 years ago

Bruce_Fei , Summarize will remove duplicate try like

SUMMARIZE(Sheet1,Sheet1[objects],Sheet1[Month],Sheet1[mat],"totalBuild",COUNT(Sheet1[mat]))

Bruce_Fei's avatar
Bruce_Fei
Regular Visitor
5 years ago

amitchandak thanks for your support.

i get the summarize table.

 

could you please help me another question?

now i get two tables base on your solution, i need append these two table to one table. the different column is "totalBuild" and "totalfail". i can't direct append via query editor. how to write the DAX?

 

thanks.