Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
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.
Hi @analystict,
Could you please create some sample table and list the expected result for further analysis?
Best Regards,
Angelia
User | Count |
---|---|
117 | |
75 | |
61 | |
50 | |
44 |
User | Count |
---|---|
174 | |
125 | |
60 | |
60 | |
57 |