Forum Discussion
Merging columns and add new fields
Hi,
I have the following dataset:
...and i am trying to merge columns (from Initial Interest Conversion Time) untill PO this Quarter Conversion Time), so then i have the average of each of those columns, per stage, per day..
the end result should look like this more or less:
(i dont need to have all the dates in the calendar; only the dates in the Opportunity Created Date column in the illustration above)
the idea of doing this is to, when building a clustered bar chat, i can have the stages as a Legend with ther respective values.
So if someone have a better idea on how to get this illustration without doing a workaround with the data, it is also valid.
Thank you very very much!
3 Replies
- edhansCommunity Champion
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.- danielcontenteHelper II
Hi,
Thank you for helping.
How do i share a CSV/EXCEL file?
Thanks
- v-kelly-msftCommunity Support
Hi danielcontente ,
You could upload your excel or csv to a Cloud Service then share a public link with us.
Remember to remove the confidential information.
Best Regards,
KellyDid I answer your question? Mark my post as a solution!