0
0
Power BIbi_tool~10 mins

Publishing reports in Power BI - Cell-by-Cell Formula Trace

Choose your learning style9 modes available
LearnWhyDeepSheetTryChallengeScenarioRecallDash
Sample Data

This table shows report names and their current status before publishing.

CellValue
A1Report Name
B1Status
A2Sales Overview
B2Draft
A3Customer Insights
B3Ready
A4Inventory Report
B4Ready
A5Financial Summary
B5Draft
Formula Trace
IF(B3="Ready", "Publish", "Do Not Publish")
Step 1: B3="Ready"
Step 2: IF(TRUE, "Publish", "Do Not Publish")
Cell Reference Map
    A                 B
1 | Report Name      | Status    |
2 | Sales Overview   | Draft     |
3 | Customer Insights| Ready     | <-- referenced cell
4 | Inventory Report | Ready     |
5 | Financial Summary| Draft     |
The formula checks the status in cell B3 to decide if the report is ready to publish.
Result
    A                 B           C
1 | Report Name      | Status    | Publish Status |
2 | Sales Overview   | Draft     |               |
3 | Customer Insights| Ready     | Publish       |
4 | Inventory Report | Ready     |               |
5 | Financial Summary| Draft     |               |
The formula in column C for row 3 shows 'Publish' because the status in B3 is 'Ready'.
Sheet Trace Quiz - 3 Questions
Test your understanding
What does the formula IF(B3="Ready", "Publish", "Do Not Publish") return when B3 is 'Ready'?
AError
BDo Not Publish
CPublish
DBlank
Key Result
IF(condition, value_if_true, value_if_false) checks a condition and returns one value if true, another if false.