Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
I have a measure created as following:
Solved! Go to Solution.
Hi @Anonymous
Please check if this article could help you.You may try below measure.If it is not your case,please share some sample data which would be helpful to provide an accurate solution.You can upload the .pbix file to OneDrive and post the link here. Do mask sensitive data before uploading.
Measure = CALCULATE ( [DCA Mgmt YTD], PREVIOUSYEAR ( 'date table'[Date], "03/20" ) )
Regards,
Cherie
Hi @Anonymous
Please check if this article could help you.You may try below measure.If it is not your case,please share some sample data which would be helpful to provide an accurate solution.You can upload the .pbix file to OneDrive and post the link here. Do mask sensitive data before uploading.
Measure = CALCULATE ( [DCA Mgmt YTD], PREVIOUSYEAR ( 'date table'[Date], "03/20" ) )
Regards,
Cherie
User | Count |
---|---|
126 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
137 | |
116 | |
102 | |
71 | |
61 |