Skip to main content
Microsoft Idea

Power BI

Merged

ENTER NOT SHIFT-ENTER IN DAX FORMULA BAR

Vote (5) Share
Claire Allwood's profile image

Claire Allwood on 13 Aug 2021 05:46:47

This is soooo frustrating. I know full well that you have to press SHIFT-ENTER to get a line feed in the DAX formula bar BUT when you are deep in coding mode your reflexes take over and when your brain thinks 'new line please' your fingers automatically hit Enter.

So then PowerBI starts chugging through the calculation. You CANNOT stop it (another annoyance). It can take minutes each time if you are working on large data sets. You know it is not going to work, because the code isn't finished, but you have to sit and wait for PBI to tell you that.

Either change it to Enter and just make it that you have to click the tick to run the code (fine by me) OR give a 'Do you want to run this code' kind of warning.

Again, the fact that you have chosen Shift Enter for the formula bar, and Enter to run the code has no basis in common sense or logic. It DOES NOT improve useability.

PLEASE, PLEASE change this, or allow us to change it.