https://community.databricks.com/t5/warehousing-analytics/dynamic-measure-calculation-based-on-filter-in-excel/m-p/50693#M1035 <P>Thanks&nbsp;<a href="https://community.databricks.com/t5/user/viewprofilepage/user-id/9">@Retired_mod</a>&nbsp;, I think Power Query can only perform pre-data transformations, not on-the-fly calculations in response to user filters.</P> Thu, 09 Nov 2023 01:52:20 GMT cyong 2023-11-09T01:52:20Z https://community.databricks.com/t5/warehousing-analytics/dynamic-measure-calculation-based-on-filter-in-excel/m-p/50615#M1029 <P>Hi, currently we are using Power BI as the semantic layer because it allows us to build custom measures to do aggregates and business logic calculation,&nbsp;and provides native connection to Excel. I am thinking to move these logics to Databricks using SQL view, however I am wondering if the dynamic measure calculation based on filter selection can still be achieved in Excel, e.g. dynamically change sales amount based on currency filter? Thanks.</P> Wed, 08 Nov 2023 09:51:22 GMT https://community.databricks.com/t5/warehousing-analytics/dynamic-measure-calculation-based-on-filter-in-excel/m-p/50615#M1029 cyong 2023-11-08T09:51:22Z https://community.databricks.com/t5/warehousing-analytics/dynamic-measure-calculation-based-on-filter-in-excel/m-p/50693#M1035 <P>Thanks&nbsp;<a href="https://community.databricks.com/t5/user/viewprofilepage/user-id/9">@Retired_mod</a>&nbsp;, I think Power Query can only perform pre-data transformations, not on-the-fly calculations in response to user filters.</P> Thu, 09 Nov 2023 01:52:20 GMT https://community.databricks.com/t5/warehousing-analytics/dynamic-measure-calculation-based-on-filter-in-excel/m-p/50693#M1035 cyong 2023-11-09T01:52:20Z