Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
SRA
Regular Visitor

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

‎04-05-2022 12:56 PM

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.

Labels:
Message 1 of 4
295 Views
0
3 REPLIES 3
tackytechtom
Super User
Super User

‎04-05-2022 01:02 PM

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 

Message 2 of 4
293 Views
0
SRA
Regular Visitor
In response to tackytechtom

‎04-05-2022 02:09 PM

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

Message 3 of 4
257 Views
0
v-easonf-msft
Community Support
Community Support
In response to SRA

‎05-06-2022 01:27 AM

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

Message 4 of 4
231 Views
0

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

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

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

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

View All