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.
Hello to the community,
Currently, I'm stuck with this data transformation in power query editor :
I have one table named "seasonality" with all the dates of the years :
I have a second table named "Data Equipment" with several ID :
And I want combine this tables with this transformation : for each dates, add all rows with this IDs
Desired result
If someone can help me.. or offers me another solution of transformation, group by etc..
Thank you in advance !
Solved! Go to Solution.
2 things:
1 - to get more detail on errors, click in the error box (not on the error) and you'll get a further details below the dataset.
2 - did you write that code yourself because there's a lot wrong with it. I suggest deleting the step.
After that, click the 'custom column' on the Add Column menu. In the formula box put the name of the other table (if you write # , intellisense should offer you the name). Click OK.
If that works, expand the column header to return the correct field.
2 things:
1 - to get more detail on errors, click in the error box (not on the error) and you'll get a further details below the dataset.
2 - did you write that code yourself because there's a lot wrong with it. I suggest deleting the step.
After that, click the 'custom column' on the Add Column menu. In the formula box put the name of the other table (if you write # , intellisense should offer you the name). Click OK.
If that works, expand the column header to return the correct field.
Thanks a lot ! It's working ! 😁
I'm beginner with Power BI so I didn't know this trick..
I can help if you tell me what you've got so far. Any errors?
Here is my error
Here is my error
In seasonality, add custom column and just put the name of the 2nd table. You can then expand the header.
If the 2nd table has many colmuns but you just want to add one then just put the Table[columnName] in the Add custom column code box. You will then be able to expand the list to new rows
This solution not working or may be I didn't understand
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.