My data is in the following format
i want to transform the data to
it will be nice if you could please guide me in the right direction on how to achieve this.
Thanks in advance.
Hi @MohammedAli ,
Did I answer your question ? Please mark my reply as solution. Thank you very much~
If not, please upload some insensitive data samples and expected output.
You could follow these steps:
1. Pivot the "Pay type" column and use "Amount" column as values.
2. Change data type of "Effective From/To" columns to Date.
My transformed data and visualization look like this:
Is the result what you want? If not, please upload some data samples and expected output.
Please do mask sensitive data before uploading.
Best Regards,Eyelyn Qin
In Power Query Editor duplicate the date column and transform it to year as below and duplicate again and transform it to Month.
After transforming these will be avaialble as columns for you to use in the report.
Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!Regards,Pranit
Learn how to create your own user groups today!
Click here to read more about the October 2021 Release!
Check out the new Power Platform Community Connections gallery!
Mark your calendars and join us for our next Power BI Dev Camp!