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.
Hi All,
(This is my first post, so please correct me if I need to change anything. Thanks! :))
I am having an issue modelling data in my PBI model. It seems like a simple task, but I cannot get my head around it.
In short:
I would love to be able to link to the table using the field "Dimension ID", but this is only possible for me, if the value is unique.
In the linked excel file, I have tried to explain the issue with two tables;
I hope a bright mind will be able to guide me in the right direction. (Perhaps someone will even upload a .pbix file showing the steps needed to manipulate the data?)
For those who are interested:
This is a Dynamics NAV issue, where dimensions are stored as Dimension Set IDs to conserve space on the database (and to ensure performance), but this creates issues when people (me! :)) want to look across all dimensions of a given transaction. So if I'm able to create unique values of the dimension set IDs, I'll be able to slice across all dimensions. (which would be awesome! :))
Best
Martin
Solved! Go to Solution.
I'm going to call out to @ImkeF once again as I think that you should be doing that in Power Query.
You're looking for a pivot-operation (without aggregation).
See file attached.
Imke Feldmann (The BIccountant)
If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!
How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries
I'm going to call out to @ImkeF once again as I think that you should be doing that in Power Query.
You're looking for a pivot-operation (without aggregation).
See file attached.
Imke Feldmann (The BIccountant)
If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!
How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries
Sorry for the delayed feedback (haven't been able to log in for some time.)
This is perfect, and exactly what I was looking for!
Thank you!
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 | |
76 | |
74 | |
49 |
User | Count |
---|---|
145 | |
108 | |
107 | |
89 | |
61 |