Forum Discussion
Automated List Management
The goal is to automate my list managment process for software deployments. I am looking to create a calculated column, that will take a few filters and row count inter consideration. For e...
HI, Anonymous
You could try this way:
First add an index column. Refer this post: https://community.powerbi.com/t5/Desktop/Creating-calculated-index-column-in-DAX/m-p/635397#M303922
Second, divide this index column by 50 (Integer)
INT((Table1[Index]-1)/50)
Then get result column
group = "Wave "&INT((Table1[Index]-1)/50)+1
For example:
In my simple sample, I use 3 instead of 50
Best Regards,
Lin
Also, just a thought. It would be useful if I could grab the category of another column for the naming convention of these migration waves. For example, if the user is located in Asia Pacific, the wave name would be "Asia Pacific - Wave 1"