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.
Dear All,
I am from Tableau background and my data is in Oracle DB is in below format with different countires for different years and different quaters columns.
Can any one please help me how can I convert to unstructured data
Hi, can you explain a bit more about "A,B,C,D" in the table? if you don't use them, using Q3 2019 in replace of those fields can solve the problem. You can "unpivot" the data in "Edit Queries" in Power Bi.
Regards,
Happy to help!
You Can consider it as Application name
Then I think you can merge those rows together like "A Q1 2018". Then you can do the transformation unpivot in Edit queries. This will generate a key value column. The key will be A Q1 2018 and the value the number of the table.
After that you can continue the split column by first space if you want to separate application name from Q1 2018 in two columns.
Hope this helps
Regards,
Happy to help!
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 |
---|---|
114 | |
99 | |
82 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |