Sumarize DATES from multiple tables

[cristianml]

Hi,

I need to create a calendar table based on 2 or 3 tables dates.

Calendar = SUMMARIZE(Actuals,Actuals[Date]) && SUMMARIZE(Backlog,Backlog[Date])

How is the best way to do this ?

I also tried this :

Calendar_ =

VAR _ACTUALS = GROUPBY(Actuals,Actuals[Date])

VAR _BACKLOG = GROUPBY(Backlog,Backlog[Date])

RETURN

SUMMARIZECOLUMNS(_ACTUALS,_BACKLOG)

[Anonymous]

Hi @cristianml ,

Is there anything else you need help with regarding this post? If not, could you please mark your reply as Answered? It will help the others in the community find the solution easily if they face the same problem as yours. Thank you.

Best Regards

[cristianml · Accepted solution]

I found it !

Calendar = UNION(SUMMARIZECOLUMNS(Actuals[Date]),SUMMARIZECOLUMNS(Backlog[Date]))