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,
I need your help.
I'd like to reorganized datas from this table with M.
I want to create a fonction that will read "Line Items" and create a list with all distinct values.
Then, from the list, create new tables, one per item in the list and associate all datas from the fields "Time", "Attribut" and "Valeur".
To be perfectly clear, at the end, I would have:
A table named "Réel Ytd" with fields "Time", "Attribut" and "Valeur",
Another table named "Réel" with fields "Time", "Attribut" and "Valeur",
...
I can use the actual table as it is, but I'll have to use a lot of mesures. It's not a real problem, a bit longer to design the dashboard. But working from many tables with less mesures would be easier to understand and to maintain the dashboard, for my customer.
Maybe I could obtain the same result with an other way, datas come from Anaplan, in fact, datas come from a cube in .csv format.
Thanks by advance for your help,
Ludo
Solved! Go to Solution.
AFAIK There is no way to do it. Power Query certianly cannot. You might be able to script it on Tabular Editor, but that would require you to enable unsupported functions, and any issues (even if possible) will not be supported by MS. They don't support T/E editing M and creating objects.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingWe need data, and a good mockup of expected results. I'm not typing in all of that data in the image.
How to get good help fast. Help us help you.
How To Ask A Technical Question If you Really Want An Answer
How to Get Your Question Answered Quickly - Give us a good and concise explanation
How to provide sample data in the Power BI Forum - Provide data in a table format per the link, or share an Excel/CSV file via OneDrive, Dropbox, etc.. Provide expected output using a screenshot of Excel or other image. Do not provide a screenshot of the source data. I cannot paste an image into Power BI tables.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingOK, sorry, that was my first post.
The goal is to transform the "Line items" column into tables containing the others fields (following screenshots)
The source :
What I need:
The first disctinct value (in the black rectangle) becomes the name of a new table containing datas of the red rectangle.
Then next distinct value, until the end.
With the datas below, I should have a bit less than 20 tables at the end.
The result with the first value of Line Items Column:
To complete, here are some datas.
VersionsLine ItemsTimeACTIVITE COMMERCIALE- Détails- Bloc
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
I think it's better to find the solution now.
Thanks to all.
Ludo
Are you wanting Power Query to create those tables? It cannot. Power Query cannot create other objectes (lists, tables, values, etc) - it can only manipulate the data it has. It can convert the existing data into a table, list, or whatever, but it cannot create other objects on that side pane.
If that isn't what you mean, please advise.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingHi Edhans,
I want new tables based on the source "Run Export Action", maybe another way exists to do it, but I want to do it with Power BI.
In fact I want to split "Run Export Action" to obtain many tables to resume, it doesn't matter how, but with Power BI.
Regards,
Ludo
AFAIK There is no way to do it. Power Query certianly cannot. You might be able to script it on Tabular Editor, but that would require you to enable unsupported functions, and any issues (even if possible) will not be supported by MS. They don't support T/E editing M and creating objects.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingToo bad.
Thx Edhans
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 |
---|---|
100 | |
51 | |
19 | |
12 | |
11 |