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.
Take a look at the September 2023 Power BI update to learn more.
Join Microsoft Reactor and learn from developers.
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!