InternetPreviousQuarterMargin:=CALCULATE([InternetTotalMargin], PREVIOUSQUARTER('DimDate'[Date]))

[hongdao]

I am learning how to implement tabular models using the InternetSales dataset from AdventureWorksDW2019 through the link https://learn.microsoft.com/en-us/analysis-services/tutorial-tabular-1400/as-lesson-6-create-measure....

I followed the steps in the tutorial, but in Lesson 6: Create Measures, when I input the formula 'InternetPreviousQuarterMargin:=CALCULATE([InternetTotalMargin], PREVIOUSQUARTER('DimDate'[Date]))', the result for InternetPreviousQuarterMargin shows as blank.

I’ve checked the previous steps from the tutorial, but I haven’t been able to resolve the issue. I’m wondering if anyone else has faced this situation and can guide me on how to fix it. Thank you.

[BeaBF]

@hongdao Hi! 

Verify that the date column in the 'DimDate' table is set to the "Date" data type

BBF

[hongdao]

I have already done it, but it still doesn't work

[v-zhouwen-msft]

Hi @hongdao ,

Regarding your question, you are using the time smart function, which requires consecutive and unique date columns. Make sure step 3 of the documentation is correct.

What is the specific expression for this metric? Which table is it calculated for? Depending on the direction in which the filter is passed, the date dimension table can only filter data from table 'FcatInternalSales'.

Best Regards,
Wenbin Zhou

[hongdao]

I created the column InternetTotalMargin = SUM([Margin]), where the Margin column is calculated as [SalesAmount] - [TotalProductCost] in the FactInternetSales table