GAMMA Distribution DAX Functions
Add a gamma distribution function and an inverse gamma distribution function, analogous to the Excel GAMMA.DIST and GAMMA.INV functions. These are incredibly useful under many circumstances where the k parameter is not constant and the exponential distribution is not applicable.
SharePoint Online Schedule Refresh
Allow SharePoint Online connections in Power BI online to have a scheduled refresh. Currently, only manual refresh is allowed. This would allow easy data input to sharepoint and up-to-date output in BI online.
Customize Keyboard Shortcuts
Enable users to customize keyboard shortcuts in the desktop version.
DAX Gamma Function
Create a Gamma function in DAX, like the GAMMA function in Excel (not the GAMMA.DIST or GAMMA.INV). This is incredibly helpful in modelling many distributions, including a Beta distribution, Skewed Generalized T Distribution, and more. Enhancing the statistical package in Power BI would make it a...
page level use relationship
Set an alternate relationship by report page. Similar to the USERELATIONSHIP () function, but overriding all measures in use on a particular page unless they have a higher priority (e.g., they specify a different USERELATIONSHIP () or filter). An example application would be having an entire ...
Change Zero to Blank Function
Often in reports, it is convenient and simplifies content to display zeroes as blanks. Current the DAX VAR Print = 'code here' RETURN IF(Print=0,BLANK () ,Print). This could be simplified by a function ZEROTOBLANK () or similar to replace this.
Export Power Query Connection File
Add function to export Power Query queries to a file for import into either Power Pivot or another Power BI report.
Desktop Process Name by File Name
Other Microsoft Office products differentiate the process by the file name opened in Task Manager. However, Power BI Desktop affords no such convenience. Perhaps we could have the file name included in the process description for easier resource management? See attached screenshot for Excel vs P...
Cancel Model Change
In large models, whenever a column or measure is created or modified, the model can take a long time to update. However, often as soon as I hit enter and the "Working on it" box pops up, I notice an error in my code. It would be helpful to be able to cancel these and return to the DAX editor, sim...
DAX Pipe Operator
A DAX pipe operator would allow function outputs to be piped to another function rather than nesting or written to a variable. This would streamline code writing. E.g.: SUMMARIZECOLUMNS () %>% ADDCOLUMNS () %>% FILTER () rather than: FILTER(ADDCOLUMNS(SUMMARIZECOLUMNS () ))