How to compare Actuals vs. Targets in Power BI Desktop using 12-month data from multiple files

In this video, we use data from multiple files, located in the same folder. Some very interesting Power Query steps are used in order to prepare the data.

[@stefanodegemmis2518]

That transformation of the data was amazing! Even tho, it's mostly irrilevant for many people who are looking for this solution: Data is most of the time already organized properl to work, so after the 10 min the video is relevant for the issue addressed of Actuals vs target

[@TheJPhotos]

Very nice! Exactly what I needed!

[@irexhepi]

Very interesting data transformation, nice job

[@mohammedaltaf4877]

Excellent Work Brother

[@mohammedaltaf4877]

excellent Job

[@mohammedaltaf4877]

fantastic

[@mohamedalimohamed2634]

Hi i have a question that is:- I have questionnare in Excel may i use in power BI so as to make chart?

[@BIDataLab]

Yes you can

[@mohamedalimohamed2634]

Well! How?

[@BIDataLab]

@@mohamedalimohamed2634 can you send the file so we could check?

[@mohamedalimohamed2634]

@@BIDataLab yeah

[@mohamedalimohamed2634]

@@BIDataLab tell me where am l sending the file?