Forum Discussion

Dismissile's avatar
Dismissile
Regular Visitor
9 years ago
Solved

Problem with DAX sample / tutorial

I'm trying to follow the tutorial located here on DAX: https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-quickstart-learn-dax-basics/   In the article it says you need to download ...
Need Help
  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    9 years ago

    Hi Dismissile,

     

    The sample file is used for explaining the DAX usage instead of data refresh, all data are imported to the data model, you can create measures follow the tutorial.

     

    Is there any special reason you want to refresh this sample file?

     

    Best Regards,
    QiuyunYu

v-qiuyu-msft's avatar
v-qiuyu-msft
Community Support
9 years ago

Hi Dismissile,

 

The sample file is used for explaining the DAX usage instead of data refresh, all data are imported to the data model, you can create measures follow the tutorial.

 

Is there any special reason you want to refresh this sample file?

 

Best Regards,
QiuyunYu

Bamse's avatar
Bamse
Frequent Visitor
6 years ago

Nowadays (oktober 2019) there's a good reason to wish to update the data(model)!
The calendar/data ranges from 2005 until the 31st of december 2018.
That means that the examples in the training do no longer work.

Take the first assignment for creating a measure:
Previous Quarter Sales = CALCULATE(SUM(Sales[SalesAmount]), PREVIOUSQUARTER(Calendar[DateKey]))
There has been no sales since Q1 2018 so the result will be empty now.