We continue exploring data refinements using Power BI. In these videos we cover Grouping on dates, numbers and text along with creating hierarchies.
Comprehensive video showing very useful ways of using VLOOKUP. Explains when to use Range Lookup with easy examples.
Learn why in this short, 5-minute video.
More articles on VLOOKUP are here
We have already learnt how to import and clean data from various sources using Power Query (Transform). Once the data is inside Power BI Data tab (or Excel Data Model of Power Pivot), we can refine and enrich it further using various features like synonyms, custom sorting order, formatting, summarization and more. Watch the video for details – English as well as हिंदी versions are available.