Forum Discussion
Helper IAggregate rows on months with DAX
You might check this oldy but goody:
http://www.powerpivotpro.com/2012/01/salesbudget-integrating-data-of-different-grains/
Helper IHi Anonymous,
thanks for your answer, I have some questions on your solution.
1. In the Tables Actuals, Budget and Calendar I have a column with Date (Datetyp: Date). Why isn't this enough relation between them?
2. What do you mean by "Join"? Join them in an additional table? Or join them in DAX?
3. Doesn't the CALCULATE need an additional operator? Something like CALCULATE( SUM( 'Budget'[Budget] ), DATESYTD( 'Calendar'[Date] ) )
I really appreciate your help!
What I meant by join was the relationship between the tables using Manage Relationship in Power BI.
Yes you can use the additional operator in CALCULATE. If the Budget is a measure defined as sum('Budget'[BudgetAmount]), then you dont need to put SUM in the first parameter of CALCULATE.
Hope this calrifies.
Cheers
CheenuSing