Format and sorting of lookup table - does it make a difference to performance?

[michellepace]

I have the below lookup table where DocumentNumber is unique.

Question:

Does it make a difference to the speed in which a lookup can be done, if I were to (1) change the type of DocumentNumber to a whole number; (2) sort DocumentNumber?

Thanks,

Michelle

[v-diye-msft · Accepted solution]

Hi @michellepace 

Follow this blog to install the Dax studio

then connect the opened pbix file in Dax studio

or you can use the Performance Analyzer in the Power BI Desktop, please refer to this document:

https://docs.microsoft.com/en-us/power-bi/desktop-performance-analyzer

[Anonymous]

Het @michellepace 

You can try and test with the perfomance analyzer.

Cheers!
A