Forum Discussion

analystict's avatar
analystict
Helper I
8 years ago

Measure with fields from two different tables

Hi,

 

I currently have two fields in a table called leads which are created_on and conversion_date (both date fields with existing hierarchy).

 

There is also a calculated measure which calculates the count of created_on in July and the count of conversion_date in July. What I did is I tried to sort by Month of created_on, and set both fields in the table.

 

The problem is, that conversion_date can be July and created_on can be June, which will not be counted in this case per month properly (separate measures).

 

I tried using the ALL function but it did not solve the issue, I'd appreciate some help.

1 Reply

  • v-huizhn-msft's avatar
    v-huizhn-msft
    Microsoft Employee

    Hi analystict,

    Could you please create some sample table and list the expected result for further analysis?

    Best Regards,
    Angelia