topic Re: InternetPreviousQuarterMargin:=CALCULATE([InternetTotalMargin], PREVIOUSQUARTER('DimDate'[Date])) in DAX Commands and Tips

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

hongdao — Tue, 15 Oct 2024 18:48:52 GMT

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-measures?view=asallproducts-allversions.

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.

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

Anonymous — Wed, 16 Oct 2024 07:42:33 GMT

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

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

BeaBF — Wed, 16 Oct 2024 07:45:24 GMT

hongdao Hi!

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

BBF

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

hongdao — Wed, 16 Oct 2024 11:41:55 GMT

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

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

hongdao — Wed, 16 Oct 2024 11:44:59 GMT

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