Forum Discussion
Conditional columns
Hi, I have a table with monthly company data for 3 years. I am trying to reshape my table and make new columns for some of the metrics using conditional columns. My table looks like below: ...
Jihwan_Kim I see the confusion. That is for another company (company B). So I'd like to have one row for each month per company 🙂 .
Hi,
Thank you for your feedback.
Please correct me if the link down below is not what you are looking for.
You can open it and go into Power Query, and you can check whether it is correctly done or not.
Thank you very much.
https://www.dropbox.com/s/9h1cobfb3i4te43/Fereshteh.pbix?dl=0
Hi,
Thank you for your help, unfortunately I could not make it work with your proposed solution. I removed my Revenue and Cost columns and kept the year, company and the Year-to date column that I calculated from Revenue. It looks fine now.