The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now
Hi,
Using Contoso Sales file in PowerBI desktop.
1. How to check the output of New measure created :
2. Dragging this measure on Report Canvas is not producing any visual.
Regards,
Dhiraj Tuteja
Hi @DhirajTuteja,
Could you please mark the proper answers as solutions?
Best Regards,
Dale
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
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
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
Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.
User | Count |
---|---|
157 | |
106 | |
96 | |
83 | |
75 |
User | Count |
---|---|
153 | |
137 | |
131 | |
81 | |
61 |