Forum Discussion
Ranking
I am new to Power BI and Dax all together and am trying to learn. I have a table with 3 columns: ID, Company, Amount. I am trying to rank the amount from the company by ID. I believe i need a mea...
Wow, I did not even know the query editor existed, but as I said I am very new to Power BI. It is great to see so many different ways to solve a problem, it really helps someone trying to learn, Thanks!
Based on these two methods, which do you think is more efficient, which method should one use going forward?
In general, any time you can bring in a column from the source data or from the query editor, it will have better compression. However, with measures, it is better to use DAX. In the case of the RankX measure, it is probably better to use DAX, but for my sanity I used the query editor ;)