Forum Discussion
Helper IIDax
Hello good people, I was given the assignment below to solve this. As a newcomer in PBI, I find it confusing. I tried hard and solved the problem, but it seems I actually messed up with the solution. Now I've submitted the solution file and I will be happy if someone kindly solves the problem so that I can learn from my mistakes. Could anyone please help me with the solution?
https://drive.google.com/file/d/1FhyexInp3ghfep3BG0wnPUoFX_Ki1O9m/view?usp=sharing
Case:
Executives at a local grocery distributor are looking for some analysis on the data they have provided in the tab named SAP Data Extract.
1. Assume the current date is November 15, 2016.
- Use a Calendar Dimension ( PowerQuery)
- Achieve this by using a slicer, so we can dynamically check another date
2. We would like to see the current year-to-date growth rate.
3. We would like to see that using Calcualte & DATESYTD () function
4. Call out any anomalies in the data as well as present any visuals that help them make better choices in the direction they want to take.
3 Replies
- amitchandak
Super User
Alex_Hasan , if you have date table marked as date table, then you can create a measure like example
YTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD('Date'[Date],"12/31"))
refer if needed
Power BI — Year on Year with or Without Time Intelligence
https://medium.com/@amitchandak.1978/power-bi-ytd-questions-time-intelligence-1-5-e3174b39f38a
https://www.youtube.com/watch?v=km41KfM_0uATime Intelligence, DATESMTD, DATESQTD, DATESYTD, Week On Week, Week Till Date, Custom Period on Period,
Custom Period till date: https://youtu.be/aU2aKbnHuWs&t=145s
Alex_HasanHi amitchandak , what would be the dax for total sales here? Because I need to calculate it properly.
Is it SUM(Sales[Net Sales])?
- v-chenwuz-msft
Community Support
Hi Alex_Hasan ,
Did you want sum all the sales until the selected date?
Maybe you can try this measure to do that.
Measure = CALCULATE ( [Total sales], FILTER ( ALLSELECTED ( Dim_Date ), [Date] <= MAX ( 'Dim_Date'[Date] ) ) )
Best Regards
Community Support Team _ chenwu zhuIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
