Forum Discussion
Anonymous
3 years agoNot applicable
Sorting columns out based on data
Hello, I am importing data from Asana into PowerBI with the hopes of tracking the amount of time spent on tasks and tracking which users are spending X amount of their time on which tasks. Since ...
- 3 years ago
Hi Anonymous ,
thanks for the data. What you have to do is a pivot-operation on your "Custom Fields.name"-column with the parameters like shown below:
ImkeF
3 years agoCommunity Champion
Hi Anonymous ,
that looks doable. Please provide sample data like described here and I can show you the solution: How to provide sample data in the Power BI Forum - Microsoft Power BI Community
Anonymous
3 years agoNot applicable
Hello Imke,
Thank you! I have saved the test file here:
https://drive.google.com/file/d/1qYuByO160eqtr-BIRvuAxd9LO9tM0b3s/view?usp=sharing