1. Imagine this- you’ve been handed two tables: Sheet1 has 6 records, Sheet2 has 4. Now, we know 4 of those are common in both tables. Can you walk me through how you’d find the 2 records that only exist in Sheet1? You can pick any approach→ Power Query or DAX.
2. Suppose your Sales fact table has two date fields: OrderDate and DeliveryDate. Now, your Date table is only connected actively to OrderDate, while DeliveryDate has an inactive relationship. How will you still calculate total revenue based on DeliveryDate?
3. Suppose you're working as a sales market analyst in India for a product-based company. You need to show the Top 5 products based on total profit. How will you do that using DAX?
4. Suppose: You have a folder with three CSV files: product_list_1, product_list_2, and product_list_3. How would you combine all these files into a single table inside Power BI?
5. Suppose you have a dataset with Country and Total Sales, and you're showing the sales value on a Card visual. The twist is: by default, the user wants to see India’s sales (50K), not the full 100K total - unless they select a different country using a slicer. How would you solve this?
6. Suppose you’ve got two date columns: Order Date and Delivered Date. How would you calculate the total number of business days between the two?
7. Suppose you have sales on the Y-axis and months from January to December on the X-axis. But the client wants to see the fiscal year from April to March. How will you handle that?
8. Suppose the user wants to dynamically select Top 2, Top 3, or Top 5 products by sales using a slicer — how would you implement that in Power BI
9. How do you calculate a running total or cumulative sales in Power BI using DAX?