Perform Complex Data Transformations in Power Query | Ultimate Example | PowerBI | MiTutorials

Perform Complex Data Transformations in Power Query | Ultimate Example | PowerBI | MiTutorials
Dataset to Practice: drive.google.com/file/d/1V-DQ...
How to Transpose Data in Power Query / PowerBI
How to Pivot Columns in Power Query

[@ravitejagollapudi778]

Loved it...Its main focus on playing with Pivot & Unpivot. Thanks for brining up🙏

[@Sirigineedi_Navann]

Simply superb kudos to your greatest efforts👏👏👏

[@MITutorials]

Thank you so much 😀

[@maesolo]

@MITutorials: Thanks for this video, I am looking at others in your channel. I have a question... if later on I have the same source Excel file that you have but now with more data (added more dates), if I need to import that again to PowerBI, I would have to do the same transform steps you took? every time we import that file, I would have to repeat transform steps?

[@tanweerabbasabbas649]

thk u dear.

[@prajwalborse2885]

Helpful Tips 👍 Can you please provide dataset?

[@MITutorials]

I have updated the Dataset link in the description ! 👍

[@user-vv8kp2le5c]

Thank you for your video) Why dou you use pivot and unpivot to select columns "CRRNT"? You can use Table.SelectColumns(List.Select(Table.CoumnNamse(...), each Text.Contains(_,"CRRNT"))) - this step I suppose that iit requires less resources

[@MITutorials]

As you know there are many ways to solve the problem.. I want to make it easy for beginners so that they don’t have to write any code.

[@GeertDelmulle]

You're right, just make sure that you don't lose the first 2 columns (from & to). Apart from that, this is exactly how I did it, too. 🙂

[@reddevil2646]

Hey,can you please provide the dataset so that we can also practise,please make a video on"how to filter the data by using DAX and add columns from different table to a new table"

[@MITutorials]

Sure I’ll make a tutorial on that. Will share the dataset tomorrow!

[@MITutorials]

I have updated the Dataset link in the description !👍

[@allinall1995]

Is it possible to give link from one cell to another cell as like we do in Excel?

[@MITutorials]

Watch this tutorial! New Dax Functions in PowerBI | Index, Offset & Window | MiTutorials kzbin.info/www/bejne/fJ7KqYurqp2prtE