QuestionQ40
VerifiedImplement and manage semantic modelsYou have a Fabric tenant containing a semantic model with data about retail stores.
You need to write a DAX query that will run through the XMLA endpoint. The query must return the total sales amount for the same period last year.
How should you complete the DAX expression?
Select
EVALUATE VAR _LYSales = ( [Total Sales], SAMEPERIODLASTYEAR ( 'Orders'[Order Date] ) ) RETURN
Community Discussion