Forum Discussion
Looping Iterated Values in Power BI
Hello mayankkverma95
you cannot do that in power query. However you can make that in dax with a measure.
Create 2 new tables... one for you selection 10, 15, 20 etc and a table for lookup where you have every combination for groups and ages and your relative group name like 10-20 or 15-30. Then create a new measure that uses lookupvalue to retreive your desired data. In the appendix you can find a easy example
If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too
Have fun
Jimmy
Hello mayankkverma95
you cannot do that in power query. However you can make that in dax with a measure.
Create 2 new tables... one for you selection 10, 15, 20 etc and a table for lookup where you have every combination for groups and ages and your relative group name like 10-20 or 15-30. Then create a new measure that uses lookupvalue to retreive your desired data. In the appendix you can find a easy example
If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too
Have fun
Jimmy