Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
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.
I have already done it, but it still doesn't work
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
I created the column InternetTotalMargin = SUM([Margin]), where the Margin column is calculated as [SalesAmount] - [TotalProductCost] in the FactInternetSales table
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
25 | |
21 | |
20 | |
14 | |
13 |
User | Count |
---|---|
43 | |
37 | |
25 | |
24 | |
23 |