Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |