Are you still writing formulas to calculate Running Total and % Total? There is a super fast way to calculate Running Total and % Total. Use this to work at a blazing speed in Excel while calculating Running Total and %Total. No more formula writing. File used in this tutorial – https://1drv.ms/x/s!Akd5y6ruJhvhvTGzqZqO-VkYFWID?e=IUzfQx
Author: Vijay A. Verma
Excel Quiz 56
Power BI – New DAX functions launched in 2022
This is a mini guide to recap those 9 functions which were launched in year 2022. PDF file corresponding to this video – https://1drv.ms/b/s!Akd5y6ruJhvhvwCdltcqWqFlen0f?e=cAzGyg
Power Query – Generate Fiscal Year – Tips & Tricks 14
Suppose you need to generate fiscal year like 2021/22, then use this formula in a custom column where 3 means FY finishes in March month. Similarly say your financial year finishes in Jun month, replace 3 with 6..If it finishes in Jul, replace 3 with 7. You will need to replace [Year] and [Month] fields…
Power Query – Sum only Numbers in a List – Tips & Tricks 13
Suppose you are given a list {"x", "100","200", "x300", 500} and you need to sum only the numbers 100, 200 and 500 in it. Then you can use following code
SQL Quiz 1
Power BI Quiz 3
Excel & Power Query Challenges Week 1
Here are 7 Excel & Power Query challenges posted on Linkedin during Week 1. You can create your own solution and also can refer to solutions posted by others to learn from others. EXCEL CHALLENGE 1 2. EXCEL CHALLENGE 2 3. EXCEL CHALLENGE 3 4. POWER QUERY CHALLENGE 1 5. EXCEL CHALLENGE 4 6. EXCEL…
Tips & Tricks 187 – Give Smilie Faces to Ratings in Dashboards / Reports
This video will help you to create Smilie Faces for values given in your reports / dashboards. They will be Green for Happy Face, Yellow for Neutral Face and Red for Unhappy Face. Excel file used in this video – https://1drv.ms/x/s!Akd5y6ruJhvhvS7bd4uLFLchcsHE?e=jBxt0d