Forum Discussion
Value range lookup - M Query
This is much easier to do with DAX in a column or a measure. Please see this post for an example.
https://forum.enterprisedna.co/t/dynamic-bin-segmentation/1250/2
If this works for you, please mark it as solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
Microsoft EmployeeThis is much easier to do with DAX in a column or a measure. Please see this post for an example.
https://forum.enterprisedna.co/t/dynamic-bin-segmentation/1250/2
If this works for you, please mark it as solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
Hi Pat
Thanks for the reply. Ive marked as solution but I am looking for an M Query solution with a view to Users not having to get involved in more complex Functions. I will carry out some performance tests as it may be the best route.
Thank you again.
Kind Regards
John