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

Totte67's avatar
Totte67
Frequent Visitor
10 years ago

Many thanks, Lydia.

I hade no drill down, becuse i missed to put in DateKey in Axis field.

Then you told me to drill down, then I saw what I have missed.

You made my weekend :-)

Best regards

Totte67