Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Solved! Go to Solution.
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
Do you mean you have a 2 part ID, like State & City? If so, you can add a caclulated column to both tables that combines the key fields into 1 then join the tables on that combined field.
@Anonymous , Can you please share some sample data and show your expected result? If you paste the data from excel directly into your post rather than a picture it makes it easier to work with also.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
77 | |
74 | |
49 |
User | Count |
---|---|
146 | |
108 | |
106 | |
90 | |
62 |