topic Re: dax for index in DAX Commands and Tips

dax for index

Anonymous — Thu, 11 Nov 2021 14:05:21 GMT

How we can write DAX to get Index coloumn in calculate table without using Generate series and Rank Functions? can any one help me

Re: dax for index

amitchandak — Thu, 11 Nov 2021 16:47:38 GMT

Anonymous , I doubt Rank and generate series are the options.

You have index column option power query, I doubt something similar in DAX

Re: dax for index

VahidDM — Thu, 11 Nov 2021 22:22:45 GMT

Hi Anonymous

As amitchandak mentioned, you can use PQ, that is the best and easiest way.

But if you need DAX, can you share more details re your request? Do you want a single column table with numbers for instance from 1 to 100?

Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/

Re: dax for index

Anonymous — Mon, 15 Nov 2021 08:23:35 GMT

Hi Anonymous ,

If you have less data, you can customize and manually enter Index

In Power query, select Add Column – Column From Examples – From All Columns.

Result：

After research, only Generate series and Rank Functions are used to create index functions, but no others are found. Can you tell me why these two functions are not used?

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.