Forum Discussion

Sandeep_4b5's avatar
Sandeep_4b5
Frequent Visitor
5 years ago
Solved

How to optimize Running total query

  I am trying to find the Running total by grouby different conditions.The following is working but its taking much time to load the data.Help me to optimize this formula. BufferedTable = Tab...
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    5 years ago

    HI Sandeep_4b5,

    What type of data source are you worked on?

    If you are working with a type of datasource that supports advanced queries(e.g. t SQL), you can try to add a custom query to directly use the query to get the result table with expected calculation fields. This result query table should have better performance than do complex summarize/aggeration by m query functions.

    Tutorial: Connect to on-premises data in SQL Server - Power BI | Microsoft Docs

    Regards,
    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
5 years ago

HI Sandeep_4b5,

What type of data source are you worked on?

If you are working with a type of datasource that supports advanced queries(e.g. t SQL), you can try to add a custom query to directly use the query to get the result table with expected calculation fields. This result query table should have better performance than do complex summarize/aggeration by m query functions.

Tutorial: Connect to on-premises data in SQL Server - Power BI | Microsoft Docs

Regards,
Xiaoxin Sheng

  • Sandeep_4b5's avatar
    Sandeep_4b5
    Frequent Visitor
    5 years ago

    It is one of the solution.But I want to try it by using DAX or PQ.