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 ...
Hi Greg,
thank you for sharing.
Measure works great, but when I trying to create custom column I have eof error after first MaxWeeks.
Do you have some idea why it's not working?
Cheers Ivan
- 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?
