Forum Discussion
analystict
8 years agoHelper I
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-msftMicrosoft Employee
Hi analystict,
Could you please create some sample table and list the expected result for further analysis?
Best Regards,
Angelia