Forum Discussion

cristianml's avatar
cristianml
Post Prodigy
4 years ago
Solved

Sumarize DATES from multiple tables

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)

 

 

 

 

 

 

Data Protection
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • cristianml's avatar
    cristianml
    4 years ago

    I found it !

     

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

     

2 Replies

  • cristianml's avatar
    cristianml
    Post Prodigy
    4 years ago

    I found it !

     

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

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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