Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi All,
I would like a formula where i can show Q1 as March total and not the cumulative or summation of all three months. Also, that Q2 would use June last recorded total number of employees. Since we wantt to create a "current view" of what the number of employees would look like.
This is what i would like to achieve:
Solved! Go to Solution.
Hey,
this article describes in great detail how you can accomplish what you are looking for:
https://www.sqlbi.com/articles/semi-additive-measures-in-dax/
The "problem/challenge" you are facing is called semi additive measure.
Hopefully this provides you with some ideas.
If not, please provide a pbix file that contains sample data and represents your data model. Upload the file to onedrive or dropbox and share the link.
Regards,
Tom
Hey,
this article describes in great detail how you can accomplish what you are looking for:
https://www.sqlbi.com/articles/semi-additive-measures-in-dax/
The "problem/challenge" you are facing is called semi additive measure.
Hopefully this provides you with some ideas.
If not, please provide a pbix file that contains sample data and represents your data model. Upload the file to onedrive or dropbox and share the link.
Regards,
Tom
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
115 | |
100 | |
88 | |
69 | |
61 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |