Forum Discussion
create a Counter which adds +1
I'm guessing this is related to the MonthIndex you were asking about in that other thread. Even if it is not you should still be able to use the same pattern. That's the only way I could come up with of sequentially incrementing a previous number that only changes on arbitrary rows. ImkeF might have another method though. I'll have to try that one out.
Edit: now that I've said that, I just came up with a way to do it in DAX. See the link for the solution. I don't want to clutter up this thread with extra code if that solution doesn't quite apply to this question.
Thought someone might find it useful as I was passing through.
Code should work fine. I am using something like it right now. Just change the names of the variables as you require.
Provides another way to solve the problem.
"each" is missing in the 3rd argument
"seq_value" becomes "seq_val"
I think you need to refresh your browser.
It looks fine to me. I did edit it after the initial post to fix this error.
Thanks for the comments though.
I just refreshed my browser. Here is my screenshot with the issues.
Nice spotting! Have edited it again to fix that.
Hopefully this helps someone.
Also I should add to this, you might find performance improvements if you usef List.Buffer() around any lists you are using.
I have used this type of approach where the tables don't perform well when using Power Query joins.
If using large data sets I would try and do all this in SQL, especially if you will be refreshing in the service.