If there is one piece of advice, I could give to DAX users, it would be to keep the structure of the model simple. That includes flattening or converting from a snowflake to a star. Take a look at this. Its an image of a model I found online some time ago. Source How does it […]
Learn how you can compare two lists, two columns or two data sets in Excel. We will look at conditional formatting, formulas and Power Query
Learn how to use XMATCH in Excel, with practice activity, workbook to download and video solution to the Problem
What is Data validation in Excel? Where is data validation in Excel? What about data validation with Excel tables or with Dynamic arrays. Learn all about Data validation in this blog post.
Learn how to lookup a value from a different table in DAX for Power Pivot and PowerBI, with no relationship using LOOKUPVALUE
Avoid Transformation steps in DAX (Excel and PowerBI) and learn to carry out data transformation in Power Query
learn to use the SORT functions in Excel, SORT and SORT by
By identifying problems before they become errors Data profiling views in power query helps to ensure your data is clean & ready to be loaded into a model
Learn how to create your favourite stock charts in Excel to visualise the price movement of your favourite stock, commodity, or cryptocurrency
Learn, step by step how to set up, manage and edit the monthly household budget template in Excel as start keeping on top of your expenses today