Skip to main content

Power BI

New

New Measure/Columns - Assume based on Context

Vote (1) Share
Tom's profile image

Tom on 05 Mar 2016 01:32:03

Currently in Power BI Desktop, within the Data pane, if you right-click on a Field in the Field List, it pops up a context-aware menu that lets you create a new measure or column. However, when it puts you in the formula box to start defining the formula, it doesn't pre-fill the column or measure that you were on, when you right-clicked to start with. It would be a real time saver and usability enhancement to pre-populate based on the column/measure you had highlighted when you started the process. For example, if my data has "PolicyNumber" in the rows, but I want to add a Measure for "Unique PolicyNumber Total", I'd like to highlight "PolicyNumber", then right-click, select "Measure", then have the new measure already be referencing "Policy Number", such as: "Column = [Policy Number]". Then, I could just scroll over before the left bracket, and type DISTINCTCOUNT, and be about done, without having to type/select the source column again.