Forum Discussion
Grouping over multiple datasets
Hello,
Thanks again for getting back to me. I did some digging and I have solved my problem!
I read this post https://community.powerbi.com/t5/Desktop/How-to-replicate-Vlookup-in-power-BI/td-p/159810
Which then directed me to this page:
https://docs.microsoft.com/en-us/dax/lookupvalue-function-dax
Which I was able to impliment into my model and effectively 'group' data by using a reference table, creating a relationship and then running the look up to give me new values I used in my visuals.
I'm very happy that I was able to make some formula work as normally I don't understand it all! (learning at I go here)
Thank you very much again.
Hello,
Thanks again for getting back to me. I did some digging and I have solved my problem!
I read this post https://community.powerbi.com/t5/Desktop/How-to-replicate-Vlookup-in-power-BI/td-p/159810
Which then directed me to this page:
https://docs.microsoft.com/en-us/dax/lookupvalue-function-dax
Which I was able to impliment into my model and effectively 'group' data by using a reference table, creating a relationship and then running the look up to give me new values I used in my visuals.
I'm very happy that I was able to make some formula work as normally I don't understand it all! (learning at I go here)
Thank you very much again.
Hello Anonymous
Excellent! Glad you were able to find a solution that works for you and thank you for letting us know and sharing the links.