Forum Discussion
Creating a new table with summarizing and distinct count
Hi,
I am trying to create a new table that will summarize some information I need. The new table will have 3 columns. I want to summarize a date column, and a zip column. However I want the third column to be a distinct count of 'orders' going to that zip code on that date. I understand i can do the summarize function for the first 2 columns, but I am having trouble with getting the third column in the table.
Thank you
Something like this should get you the table you are looking for.
Table 2 = SUMMARIZE('Table','Table'[Date],'Table'[Zip],"Orders",DISTINCTCOUNT('Table'[Order Num]))You will need to change the "Order" calculation to be applicable to your model.
3 Replies
Something like this should get you the table you are looking for.
Table 2 = SUMMARIZE('Table','Table'[Date],'Table'[Zip],"Orders",DISTINCTCOUNT('Table'[Order Num]))You will need to change the "Order" calculation to be applicable to your model.
Hi,
Share some data and show the expected result.
Hi nsessa ,
Please let us know whether jdbuchanan71 's expression is what you want.
Best Regards,
Icey
