Forum Discussion
Sort by Columns
Hello guys, I created a calculated column which helped me to categorize the tenure of my employees. The results are the following 0-30 days 31-60 days 61-90 days 91-180 days 181- 365...
Anonymous
Try changing them to this.
Tenure = VAR _Days = TODAY () - Agents[Production Date].[Date] RETURN SWITCH ( TRUE (), _Days <= 30, "0-30 Days", _Days <= 60, "31-60 Days", _Days <= 90, "61-90 Days", _Days <= 180, "91-180 Days", _Days <= 365, "181-365 Days", "+365 Days" )Tenure ID = VAR _Days = TODAY () - Agents[Production Date].[Date] RETURN SWITCH ( TRUE (), _Days <= 30, 1, _Days <= 60, 2, _Days <= 90, 3, _Days <= 180, 4, _Days <= 365, 5, 6 )
Have you created both baaed on the same column? Or you calculated buckets first and then on top of bucket you created order by.
In case you have created a bucket and order by on top of it. Then try both on the base column.
Better would be that you create a new dimension based on these values(Kind of hardcoded) and use it.
Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks.
My Recent Blog - https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601