0

Friends

Today I would like to join the result of 2 evaluate Query in DAX Query can any one have the way to do it? Following are the codes of 2 evaluate queries which i would like to join.

 evaluate
(
filter
    (
   summarize
   (
     'Total Days',
     'Total Days'[Month],
     'Total Days'[Number]
      ),  AND('Total Days'[Month]>=201601 , 'Total Days'[Month]<201612)
   )   
)

EVALUATE
filter
    (

    SUMMARIZE (
        'Sales Data',
        'Date'[DateSID],
        'Date'[Month],
        'Office'[Number]    
    )
,  AND('Date'[Month]>=201601 , 'Date'[Month]<201612)
)

I want to perform an inner join based on(Month, Number) in above 2 DAX queries. I need following table as an output.

'Total Days'[Month]     'Total Days'[Number]     'Date'[DateSID]
Nikhil.Patel
  • 959
  • 9
  • 17

0 Answers0