Power BI Insights: DAX filters; More uses of Power Query; Merging workbooks; Tracking ticket assignments

Power BI pros share insights on using the RSCustomDaxFilter, managing basic databases with Power Query, merging workbooks and more.

Working with the RSCustomDaxFilter

Power BI Report Builder users creating DAX queries may notice what seems to be a new DAX function: RSCustomDaxFilter. In fact, according to Chris Webb, the RSCustomDaxFilter gets replaced with DAX filter function filtering for specific years.

"It's just a placeholder for a dynamically-generated DAX expression that is substituted in at runtime," he wrote. This particular filtering function is helpful because it's hard to handle multiple DAX parameters without knowing how many values will get passed to the parameters.

Sometimes issues crop up, when a DAX query that is too long to run gets generated. Webb admitted he wasn't sure of the maximum number of characters, but offered a guess and shared a custom DAX example that serves as a partial workaround.

Managing a basic database with Power Query

FREE Membership Required to View Full Content:

Joining MSDynamicsWorld.com gives you free, unlimited access to news, analysis, white papers, case studies, product brochures, and more. You can also receive periodic email newsletters with the latest relevant articles and content updates.
Learn more about us here

Get full access

or login