Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
SRA
Regular Visitor

DAX Calculation of a column with 1's and 0's

I'm trying to calculate the headcount for a department throughtout the year.  The headcount varies by month so I have a column that has zeros and ones.  When I have tried to sum the column, the amount if off.  How can I get a total sum of tghe headcount for hte year so I can then calculate by month and quarter?

 

Thank you in advance for any help you can give me with the calculations.

3 REPLIES 3
tackytechtom
Super User
Super User

Hi @SRA ,

 

Please, could you share some example data so it is easier to help you 🙂

 

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/



Did I answer your question➡️ Please, mark my post as a solution ✔️

Also happily accepting Kudos 🙂

Feel free to connect with me on LinkedIn! linkedIn

#proudtobeasuperuser 

Sorry the data has proprietary information and I'm not able to share it.

Hi, @SRA 

You can provide sanitized sample data that fully covers your issue.

It will help to provide the appropriate solution.

 

Best Regards,
Community Support Team _ Eason

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.