Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 |
---|---|
101 | |
90 | |
78 | |
70 | |
69 |
User | Count |
---|---|
110 | |
96 | |
95 | |
74 | |
71 |