Posts: 55
Registered: ‎12-28-2015

Benchmark DAX Expressions



It is possible to benchmark DAX expression on PowerBI Desktop?.


I'm working with 3 measures with SWITCH function and on top of that moving averages on a line graph.


Also I have date  on the x axis as a text, because I allow the users to select his own date granularity. The dashboard with the selectors works pretty fast in 1 week, 1 month data but for 1 year takes 5-10 seconds. 


Kindly Regards,

Super User
Posts: 7,625
Registered: ‎07-11-2015

Re: Benchmark DAX Expressions

 I believe DAX Studio will let you do this.

Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

Community Support Team
Posts: 3,697
Registered: ‎07-17-2016

Re: Benchmark DAX Expressions

[ Edited ]

Hi @acanepa,


Currently, there is no any option to benchmark DAX expression on Power BI Desktop. You can use DAX Studio as suggested by @Greg_Deckler above.


In addition, here is a similar idea shared on Power BI Ideas, you can vote it up and add your comments there to improve Power BI on this feature. Smiley Happy