Create a table with calculated data from another

[frg88]

Hello, 

A table of my model has the next columns: 

• Id
• CreationDate
• DeletionDate
• Country

I want to create a new table where I have the actives items of my model for each day, I mean, the next columns: 

• Date (01-01-2018, by example)
• Country (Spain, by example)
• Active (Count of all the items which creationDate <= Date and deletionDate >= Date)

I think I can create this new table with the function ADDCOLUMNS() or SUMMARIZE(), but I haven't got it. 

Thans in advance. 

[edhans]

I'm not exactly clear on what you are trying to do, nor why you need a new table to show this data vs just a measure that will calculate it in a visual.

Can you show a sample of your current data, and a sample of the expected output?

If you are sure you need a new table, see this article, and note that SUMMARIZE and ADDCOLUMNS should generally be replaced with SUMMARIZECOLUMNS.