HOTSPOT - You are creating a Power BI model to analyze inventory. You load data into three tables named Date, Product, and Inventory. The Inventory table relates to the Date and Product tables by using one-to-many relationships. Inventory data is recorded daily with no exceptions. The correct inventory quantity for a given product in a month is the last recorded value for that month. You need to write a DAX...

Questions › Category: PL-300 › HOTSPOT – You are creating a Power BI model to analyze inventory. You load data into three tables named Date, Product, and Inventory. The Inventory table relates to the Date and Product tables by using one-to-many relationships. Inventory data is recorded daily with no exceptions. The correct inventory quantity for a given product in a month is the last recorded value for that month. You need to write a DAX…

0 Vote Up Vote Down

Admin Staff asked 4 months ago

HOTSPOT
-
You are creating a Power BI model to analyze inventory.
You load data into three tables named Date, Product, and Inventory. The Inventory table relates to the Date and Product tables by using one-to-many relationships.
Inventory data is recorded daily with no exceptions. The correct inventory quantity for a given product in a month is the last recorded value for that month.
You need to write a DAX measure that will show the correct inventory value when a user analyzes inventory by year, month, or date.
How should you complete the measure? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
 
















 

Suggested Answer: 
    



This question is in PL-300 Exam
For getting Microsoft Power BI Data Analyst Associate Certificate