Sequential
Suppose you have a list of years and weeks in those years (or months). Often, it would be nice to have a sequential number for this kind of data in order to make certain math calculations easier for ...
Sure, are you getting that error with the attached PBIX file? Or your own file?
Hi Chris, thank you for response.
I use it in my own project. The reason why it is not creating custom column, is that I use direct query data in my project.
I figured out how to use measure instead.
Cheers
Ivan
Can you please post how to use measure to create index column using Direct query?