Dynamic measure calculation based on filter in Excel

[cyong]

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, 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.

[Kaniz_Fatma]

Hi @cyong , With Power Query, you can connect to many different data sources and transform the data into the shape you want.

[cyong]

Thanks @Kaniz_Fatma , I think Power Query can only perform pre-data transformations, not on-the-fly calculations in response to user filters.