Forum Discussion
Handling Negative Entries in Data
Hello community members, I have an Excel timesheet with data on the daily work hours of employees for different projects. I am creating a Power BI dashboard to display this information. However, s...
Hi Anonymous ,
Not sure, do you want to calculate the sum of all values with positive numbers?
Total Hours = CALCULATE(SUM('Table'[Hours]),'Table'[Hours]>=0)
If I misunderstand your needs, please tell me what your expected output is and how it is calculated.
Best Regards,
Gao
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data in the Power BI Forum