Forum Discussion
Automated List Management
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
Hi Lin,
First thank you for your response and help.
The EARLIER Function only works on numeric values. I want the conditional column to be based off of user location such as NYC, Baltimore, China, etc..
This is an example of my failed attempt..
hi, Anonymous
EARLIER Function should be used as below:
Earlier(NonMHFTreeUsers[Location])=NonMHFTreeUsers[Location]
And I couldn't find out the logic of your formula, you could share some simple sample data and expected output.
Best Regards,
Lin