How do I return 0 using a DAX Calculate function in Power BI?

Question

I have the following expression and want it to return zero if the data is 0 or blank for the current pay period. Instead, it looks for the amount and if there is none for the current pay period, it moves to the previous pay period. I've tried using IF, IS BLANK, and COALESCE but I can't get it to work and I'm not super familiar with DAX. I hope this makes sense, can anyone help?

Current PP Amount = CALCULATE(SUM('Payroll and FTE'[Amount]),'Payroll and FTE'[PPE] = MAX(('Payroll and FTE'[PPE])))

Answer 1

Dear Mindy_876,

Good day! Thank you for posting to Microsoft Community. We are happy to help you.

It sounds like you query regarding DAX calculate function in Power BI. While our forum mainly deals with SharePoint features, I can guide you to the right place for Power BI-related queries.

For detailed assistance, I recommend visiting the Power BI Community. This platform specializes in Power BI issues. When posting your question, may use the 'Need help' label to get the most accurate help from the dedicated team of engineers. As our community has limited knowledge in this area,

Please accept our sincere apologies for redirecting you to another platform. The moderators in this community have limited experience and resources to support this. To ensure you receive prompt and appropriate assistance, we believe this is the best course of action.

We appreciate your patience and understanding and thank you for your cooperation.

Sincerely, Ralph Chawatama | Microsoft Community Moderator

Answer 2

Thank you for the guidance!