Calcuated columns at visual level What about to add the possibility of creating calculated columns directly in each visual properties pane? In certain cases, measures have high calculation costs and for all of other measures that depends on these we need to multiply the time to have the data out. In these cases, it could be useful to have the possibilty to create calculated column at visual level that, behind the scene, will be calculated by using the ADDCOLUMNS DAX function. Example: I have these 3 measure: [Current] = [Previous] = Calculate Current with SAMEPERIODLASTYEAR [Previous %] = (Current - Previous)/(Previous) If i use these measure in a table behind the scene PBI generates a DAX statement like this: SUMMARIZECOLUMNS ( <...filters...> <...fields...> ,"Current",[current] ,"Previous",[previous] ,"Previous %",[previous %] ) Supposing Current takes 2,5 seconds to be calculated the final query should takes at least 7,5 seconds. Instead, If i had the possibility to create column at visual level, PBI could generate a DAX statement like this: ADDCOLUMNS( SUMMARIZECOLUMNS ( <...filters...> <...fields...> ,"Current",[current] ,"Previous",[previous] ) ,"Previous %",DIVIDE([current]-[previous],[previous]) ) that take 5 seconds to return the data.
1 Comment
- fbcideas_migusrNew MemberStatus added:Needs Votes
Recent ideas
Semantic model connection bindings should be in source control (Git)
Semantic model data source connection bindings should be source controlled. A semantic model can contain multiple data source references, each of which can be mapped to a separate Fabric data connec...frithjof_v6 hours agoCommunity ChampionNew10Views1like0CommentsBulk changing column names in Visualizations Pane
We often use raw/api column names or measures with a set nomenclature to be consistent and to keep track of them but we do not want to display these names in the visuals. Currently we have to change ...vishal1401979 hours agoFrequent VisitorNew6Views0likes0CommentsAbout "Download SQL database project" and fix the downloaded project
1. The sqlproj must be fixed, it is downloaded without the xml markup line <?xml version="1.0" encoding="utf-8"> 2. The sdk must be updated: Actual: <Sdk Name="Microsoft.Build.Sql" Version="0.1...Jarrinf19 hours agoFrequent VisitorNew48Views3likes2Comments