Forum Discussion
How to Optimize my Complex dax query
Hi Guys, I really appriciate if some one gives solution for the below dax query.. The below dax query need to be optimized. How? this query running 2400 ms. So I want to optimize it. 1 Mo...
Hi ,
here is the Columns,
Hi.
I think you need to thin the table down.
Turn off Power BI's auto datetime functionality.
Separate your date related columns into a date table. (Suspect you might need two... what are the LE columns?)
Lots of blogs on date tables but this might get you started:
https://www.sqlbi.com/articles/creating-a-simpler-and-chart-friendly-date-table-in-power-bi/
You also want to separate related flags out into a separate dimension:
https://m.youtube.com/watch?v=vZndrBBPiQc
https://m.youtube.com/watch?v=vjBprojOCzU
Lastly is MERCH_FORECAST_SNAPSHOT[_Raw Forecast Qty] a measure? If so can you share it's code?