Preparing Practice Exam…
Please wait a moment while the system generates the exam questions, answers, and study session.
Please wait a moment while the system generates the exam questions, answers, and study session.
Microsoft Certified: Power BI Data Analyst Associate · Microsoft
Drag & Drop Scenario
Read the scenario requirements and decide your answer. Click Check Answer below to see the marked solution.
Hotspot Solution:
I'm totally lost with this question. VAR SalesTotal = 'Sales'[Sales].... but there is not such field in the Sales table!!! Let's assume it is VAR SalesTotal = 'Sales'[Sales Amount] "We need to create a calculated column...." I guess this column will be created in the Sales table, isn't it? If so, how are we using in the expression fields from another table? cannot see the way both tables could be linked.
Written by other learners. Comments can disagree with the marked answer — check the official documentation when in doubt.
It's Filter, And, Calculate But there is always an easier and faster way
I'm totally lost with this question. VAR SalesTotal = 'Sales'[Sales].... but there is not such field in the Sales table!!! Let's assume it is VAR SalesTotal = 'Sales'[Sales Amount] "We need to create a calculated column...." I guess this column will be created in the Sales table, isn't it? If so, how are we using in the expression fields from another table? cannot see the way both tables could be linked.
I have a question about their formula: Do you even need to declare and use the VAR SalesTotal? Why not just use the column of 'Sales'[Sales] directly in the inequality expression? I replicated this in Power BI and found that only Filter And Calculate works for me by the way.