Virvijay - Learn Excel & Power BI

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…

A running total (also called a cumulative total) shows how a number grows over time: sales so far this year, customer…

You build a matrix in Power BI, every row looks perfect, and then you look at the Total row and it is simply wrong. …