Reply
Regular Visitor
Posts: 30
Registered: ‎12-28-2015

Benchmark DAX Expressions

Hello,

 

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,

Highlighted
Super Contributor
Posts: 4,010
Registered: ‎07-11-2015

Re: Benchmark DAX Expressions

 I believe DAX Studio will let you do this.

Super Contributor
Posts: 1,520
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 @smoupre 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

 

Regards