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.
Thanks for reading. 🙂
I am currently trying to Get some data moved from one table to another while all data is connected as DirectQuery.
Issue:
The value i in order to Merge the two tables is combined with other text.
Example:
Table 1
Key | NumberOfStitches |
AFA4550 | 10.000 |
Table 2
Ordre | Description | Qty. |
1 | AFA4550: amazing stuff | 50 |
I need the NumberOfStitches as its own column on Table 2.
First issue is getting the Keu value seperated to its own coloumn in table 2 in order to connect the two tables.
The key will always end with the first : on the Description, so the rule is fairly simple.
I don't think i can just use MID in DAX as this would later require me to use LOOKUPVALUE, but this is not avaliable with DirectQuery.
Same issues goes when trying to split be delimiter in Quiry Editor. This is also not avaliabe with Direct Query.
Also it wont work doing it as a meassure using Dax, as i will need to do some more calculations afterwards that is not really possible unless i get the data moved together.
Hope it makes sence what i am trying to do.
Any help is strongly appreciated. 🙂
Quick edit:
Tables are suppose to look like this. 😄
Solved! Go to Solution.
@Thim , better to bring key as separated from DB in table 2 and create 1-M join
if this one to many relationships then related can work
Cheers. 🙂
@Thim , better to bring key as separated from DB in table 2 and create 1-M join
if this one to many relationships then related can work
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 |
---|---|
107 | |
97 | |
75 | |
65 | |
53 |
User | Count |
---|---|
144 | |
103 | |
98 | |
85 | |
64 |