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
Tips & Tricks 186 – Multi Column VLOOKUP XLOOKUP
Power BI Quiz 2
DOWNLOADS 28 – Important Shortcuts in Excel – Pinup Reference
Very useful for starters in Excel. This updated document lists down important shortcuts in Excel in one page. You can also take a print of this and paste on your desk for ready reference. This is a copyright free document, hence you can use it the way you want – both personally as well as…
DOWNLOADS 27 – CTRL+SHIFT – EXCEL SHORTCUT KEYS TO STAY AHEAD
CTRL + shortcut keys are the easiest and most often used shortcuts. Here are CTRL+ SHIFT shortcut keys listed to keep you ahead of the competition. DOWNLOAD for printing – Excel – CTRL_SHIFT_Shortcuts Pinup Reference Shortcut Action Ctrl+Shift Ctrl+Shift, then scroll your mouse wheel up to go left, down to go right Ctrl+Shift+A Insert argument…