Power BI Questions

Power BI fundamentals and usage, including data visualization, dashboard/report design, data modeling, and DAX expressions for analytics and storytelling.

MediumTechnical

88 practiced

Using DAX, write a measure called MoM Revenue Growth % for a Power BI report. The model has a marked Date table related to Sales[OrderDate], and a revenue measure already exists. The measure should compare the current month's revenue with the prior month, return blank when the prior month has no revenue, and still respect slicers such as region and product.

Sample Answer

I would create the measure like this:

dax

MoM Revenue Growth % =
VAR CurrentRevenue = [Revenue]
VAR PriorRevenue =
    CALCULATE(
        [Revenue],
        DATEADD('Date'[Date], -1, MONTH)
    )
RETURN
    IF(
        ISBLANK(PriorRevenue) || PriorRevenue = 0,
        BLANK(),
        DIVIDE(CurrentRevenue - PriorRevenue, PriorRevenue)
    )

Why this works:- DATEADD shifts the current filter context back one month- CALCULATE evaluates the existing Revenue measure in that prior-month context- It still respects slicers such as region and product because those filters remain in context- Returning blank when the prior month is missing or zero avoids misleading percentages

I would format the measure as a percentage in the model and use it in line charts, cards, or matrices. If the business later wants a different rule for zero prior revenue, I would adjust the blank logic separately from the core growth calculation.

HardSystem Design

59 practiced

Describe how you would set up daily refresh, gateway connectivity, and deployment for a business-critical Power BI report that pulls from an on-prem SQL Server and must be ready for executives by 8 a.m. What would you monitor or automate to make the process reliable?

MediumBehavioral

43 practiced

Tell me about a time you used Power BI to influence a business decision or get alignment among stakeholders. How did you handle pushback on the numbers, the definitions, or the way the dashboard was presented?

MediumTechnical

49 practiced

You need to build a Power BI dashboard for regional sales managers that tracks revenue, margin, returns, and target attainment. How would you structure the pages, visuals, slicers, and key measures so the report is useful for both quick monitoring and deeper investigation?

MediumTechnical

59 practiced

Why is a star schema usually preferred for Power BI reporting, and what trade-offs would make you choose a different model?

Unlock Full Question Bank

Get access to hundreds of Power BI interview questions and detailed answers.

Join thousands of developers preparing for their dream job.