Forum Discussion

Totte67's avatar
Totte67
Frequent Visitor
10 years ago
Solved

Measure Previous Year, get no data

have trouble seeing the previous year eg I have set up a mesure Previous Quarter Sales = CALCULATE (SUM (Sales [Sales Amount]) PREVIOUS QUARTER (Calendar [DateKey])) This has always worked in the ...
Need Help
  • Anonymous's avatar
    Anonymous
    10 years ago

    Hi Totte67，

     

    Based on my test, the Previous Quarter Sales measure works as expected. For example, after you create a column chart, dill down the date to quarter as shown in the following screenshot, you will see the sales amount of Previous Quarter in different years. 


    For more details, please review the attached PBIX file:https://1drv.ms/u/s!AhsotbnGu1NogW7rJtVIRlbhJdR0.

     

    Thanks,
    Lydia Zhang

Anonymous's avatar
Anonymous
Not applicable
10 years ago

Hi Totte67，

 

Based on my test, the Previous Quarter Sales measure works as expected. For example, after you create a column chart, dill down the date to quarter as shown in the following screenshot, you will see the sales amount of Previous Quarter in different years. 


For more details, please review the attached PBIX file:https://1drv.ms/u/s!AhsotbnGu1NogW7rJtVIRlbhJdR0.

 

Thanks,
Lydia Zhang

Waldek's avatar
Waldek
Frequent Visitor
8 years ago

hello,

 

where do i find this file:

ContosoSalesV31_64bit.accdb

?

 

thanks for help