Issue with DAX Query

[DhirajTuteja]

Hi,

Using Contoso Sales file in PowerBI desktop.

1. How to check the output of New measure created :

PreviousQuarterSales = CALCULATE(SUM(Sales[SalesAmount]), PREVIOUSQUARTER('Calendar'[DateKey]))

2. Dragging this measure on Report Canvas is not producing any visual. 

Regards,

Dhiraj Tuteja

[v-jiascu-msft]

Hi @DhirajTuteja,

Could you please mark the proper answers as solutions?

Best Regards,

Dale

[OwenAuger]

Hi @DhirajTuteja

To see a meaningful result, I would suggest including Year & Quarter dimensions on the axis of your visual.

You should also display a normal SUM ( Sales[SalesAmount] ) measure at the same time, so that you can compare adjacent quarters.

The reason you are seeing a blank result is that PREVIOUSQUARTER('Calendar'[DateKey]) returns the dates in the calendar quarter immediately preceding the quarter of the first date filtered. If you have not applied any date filters, you effectively have a "filter" including all dates in your Calendar table, so the result of PREVIOUSQUARTER will be an empty set of dates (as there are no dates before the first date in your Calendar table).

Regards,

Owen

[DhirajTuteja]

Hi,

I am referring below link :

https://docs.microsoft.com/en-us/power-bi/desktop-quickstart-learn-dax-basics

Pl let me know which step I have missed.

Regards,

Dhiraj Tuteja

[v-jiascu-msft]

Hi Dhiraj,

I would suggest you learn something about the Visuals. Please refer to guided-learning/visualizations. Every visual has its own structure and its special meanings. We can judge a DAX formula with Right or Wrong. The result depends on the context which is determined by your purpose. For example, you need to add dates for you measure like it in the snapshot below. 

Best Regards,
Dale