Join MTD and YTD Reports into One

Aug 18, 2015 at 5:57 PM
Edited Aug 18, 2015 at 5:59 PM
I have two queries: one that pulls current month metrics and one that pulls year-to-date metrics. I would like to combine the two so that on the left I have the current month report and on the right I have the year-to-date report.

The monthly report goes something like this:
EVALUATE
ADDCOLUMNS (
  SUMMARIZE (
    FILTER (
      'Metrics'
      EvalYearMonth = CurrentYearMonth
    )
  [Field1]
  ),
"Monthly Metric 1",[Metric1],
"Monthly Metric 2",[Metric2]
)
The year-to-date report goes something like this:
EVALUATE
ADDCOLUMNS (
  SUMMARIZE (
    FILTER (
      'Metrics'
      EvalYearMonth => 201501
    )
  [Field1]
  ),
"YTD Metric 1",[Metric1],
"YTD Metric 2",[Metric2]
)
I want to combine those two so the output order looks like:

Field 1, Monthly Metric 1, Monthly Metric 2, YTD Metric 1, YTD Metric 2

I've thought of using CROSSJOIN or possibly using the ADDCOLUMNS function for the monthly data within an ADDCOLUMNS function for the YTD data, but haven't had luck getting what I want yet. Does anyone have any advice for me?

Oh, and I am using version 2.1.1.33