Can you please help me on optimize my below dax to make faster performance. Can you please provide me the optimized dax?
Hi @aamirkhan_WT ,
Please refer to the following blogs to optimize your DAX formulas:
It's a little difficult to give you a suitable solution without some sample data and backend scenario(function). Could you please provide some sample in the involved tables('wt_fin_staging_pl_accounts_mapping_sorting' and 'wt_fin_staging_pl_accounts_mapping_sorting') and the functions which your above formula want to achieve? It is better if you can provide some special example to explain your expected result. Thank you.
@aamirkhan_WT , Try calculation groups or field parameters.
Calculation Groups- Measure Slicer, Measure Header Grouping, Measure to dimension conversion. Complex Table display : https://youtu.be/qMNv67P8Go0
Power BI Field Parameters — A Quick way for Dynamic Visuals: https://amitchandak.medium.com/power-bi-field-parameters-a-quick-way-for-dynamic-visuals-fc4095ae9af...
I am really not sure, why need so many formulae here.
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.