Virvijay - Learn Excel & Power BI

Before 2019 you needed AutoFilter, helper columns or a long INDEX/SMALL array formula to pull matching rows out of a …

A table full of numbers is hard to read. Add colour, and the problems jump out: red for regions below target, green f…

Your report works perfectly in Power BI Desktop. You publish it, set up scheduled refresh, and the next morning you g…

A Pivot Table is the fastest way to summarise a big list in Excel. In a few clicks you can turn 10,000 rows of sales…

"Show me our top 5 products" is one of the most common requests in any Power BI report. You can do it with …

Almost every Power BI report needs dates: sales by month, year-to-date, last year's numbers, growth. All of that …

A dependent drop-down list (also called a cascading drop-down) is a list whose options change based on what you picke…

"How are we doing compared with last year?" is the first question every manager asks. In Power BI you answe…

You write a new calculated column or calculated table in Power BI, press Enter, and get a red error: "A circular…

If you work in Excel, you look up data every day: find a price for a product code, an employee's department, a cu…