Power Bi Adding Parenthesis to End of Measure

[PBIApprentice]

I have been trying to create a new measure in power bi and every time I submit the measure, it adds an unecessary parenthesis at the end creating a syntax error (The end of the input was reached.) 

I have trying multiple different ways writing the code but nothing I do prevents this extra parenthesis from populating. If anyone else has had this issue, please let me know! Thanks!

[v-kpoloju-msft]

Hi @PBIApprentice, 

Thank you for reaching out to the Microsoft fabric community forum. Also, thanks @SamsonTruong, for this valuable insights for this thread. I have identified several alternative workarounds that may assist in resolving the thread.

You are correct that Power BI sometimes auto inserts an additional closing parenthesis if it detects an incomplete function or expression. This usually occurs due to a mismatch in your DAX syntax, such as a missing argument or function name, or if the formula editor misinterprets partial code when you press Enter.

The error message you are seeing the end of the input was reached generally indicates that DAX was expecting additional input, such as another argument or closing expression, but did not receive it before the formula ended.

Check for unbalanced parentheses in your DAX formula. You can use the formula bar’s syntax highlighting or copy the measure into Dax Formatter to help. If Power BI is auto adding a parenthesis at the end, it often means something is missing before that point review all function openings and parameters. Avoid pressing Enter midway through an incomplete function. Try writing the full expression first and then formatting.

If you can share the actual DAX measure you're working with, I would be happy to help you troubleshoot more specifically.

Kindly please refer to the below mentioned links for more information:
Measures in Power BI Desktop - Power BI | Microsoft Learn
DAX syntax - DAX | Microsoft Learn

If this post helps, then please give us ‘Kudos’ and consider Accept it as a solution to help the other members find it more quickly.

Thank you for using the Microsoft Community Forum.

[v-kpoloju-msft]

Hi @PBIApprentice,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[v-kpoloju-msft]

Hi @PBIApprentice,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.

[SamsonTruong]

Hi @PBIApprentice ,

Power BI will often auto-insert an extra parenthesis if it detects unmatched or incomplete parentheses in your DAX formula. This behavior can sometimes cause syntax issues, especially if the function is not fully written yet.

The error message "The end of the input was reached" usually means that Power BI expected more input, such as a closing parenthesis, argument, or expression, but instead reached the end of the formula. It's possible that the issue is coming from another part of the code.

If you're able to share the measure you're working on, I'd be happy to take a closer look and help troubleshoot.

Thanks,

Samson

Connect with me on LinkedIn

Check out my Blog

Going to the European Microsoft Fabric Community Conference? Check out my Session