In the query editor, there is a way to "Fill Down" or "Fill Up" in a column. It would be useful to have a way to Fill-Right or Fill-Left across a row.
lydia_rossi
6 years agoNew Member
'To fill blanks with values from another field, try this: = Table.ReplaceValue(#"Last Step",null,each [Field with Values],Replacer.ReplaceValue,{"Field to Fill 1", "Field to Fill 2", "Field to Fill 3"})
Recent ideas
Make workspace and item session persistence optional
Description The new persistent session behavior in Microsoft Fabric should be optional rather than forced. Currently, Fabric remembers the workspaces and items that were open in my previous session...TeemuMultanen11 minutes agoAdvocate INew287Views47likes2CommentsSupport Encrypted Sensitivity-Labeled Excel Files in Power Query
Description Currently, Power Query Online and Power Query in Excel are unable to access encrypted Excel files. Excel files with sensitivity types other than Public or Non-Business can be encrypted a...ewarstdhyjugkhi43 minutes agoMicrosoft EmployeeNew13Views5likes0CommentsAuto-propagate Lakehouse (Direct Lake) permissions to users assigned to a Power BI App audience
Problem When a Power BI report uses a Live Connection to a Direct Lake Semantic Model, end users must have explicit ReadAll / ReadData permissions on the underlying Lakehouse (or its SQL analytics e...majofv3 hours agoNew MemberNew5Views1like0Comments