Forum Discussion

Matan's avatar
Matan
Frequent Visitor
7 years ago

Optimize DAX Measure

Hi,   I experience slowness when i'm trying to create a measure of estimate data which is build from: Actual SAP until date of update + Manual Forecast data (*date greater than Actual max date) ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi Matan

 

You can try to download DAX Studio from http://daxstudio.org

 

You can analyse the query performance using this and then make the necessary changes.

 

If you can share the pbix in One Drive or Google drive and paste the link I can take a look at it .

 

 

Cheers

 

CheenuSing

 

 

Matan's avatar
Matan
Frequent Visitor
7 years ago

Hi Anonymous,

 

Here is the Sample File

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi Matan,

     

    I  checked the file using DAXStudio, the measure Estimated takes only 52 ms.  Please let me know where you find the slowness.

     

    Is it when building a table / matrix table or bar chart or line chart.

     

     

    Cheers

     

    CheenuSing