Merging columns and add new fields

[danielcontente]

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!

[edhans]

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.

[danielcontente]

Hi, 

Thank you for helping.

How do i share a CSV/EXCEL file?

Thanks

[v-kelly-msft]

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,
Kelly

Did I answer your question? Mark my post as a solution!