I have a fact table with expense data for many raspberry ranches. I need to report total expenses both by cycle and aggregated, this will be done in a dashboard that is already surfacing production information.</SPAN>
Each ranch has many cycles, a cycle is established by a start and stop date, cycles can be different (start and stops) for each ranch. </SPAN>
Formerly and for other commodities I’ve been using the CALCULATE formula in aggregating expenses, but now the dimension f cycle is throwing me... In brainstorming a solution for summing to a cycle, I’m not sure how I could leverage CALCULATE, if at all as there may be another solution.</SPAN>
Is a calculated measure for each ranch/cycle combination the right path of thinking? -> could I =CALCULATE (SUM(tbl_expenses), ranch=112233,dates= BETWEEN 1/1/13 AND 6/30/13, etc. ) or this wouldn’t work? I have a table that document the start and stop date for a ranch - is there a lookup feature in DAX to refer to join ranchNumber and retrieve such values? Or am I thinking about this all wrong? </SPAN>
Each ranch has many cycles, a cycle is established by a start and stop date, cycles can be different (start and stops) for each ranch. </SPAN>
Formerly and for other commodities I’ve been using the CALCULATE formula in aggregating expenses, but now the dimension f cycle is throwing me... In brainstorming a solution for summing to a cycle, I’m not sure how I could leverage CALCULATE, if at all as there may be another solution.</SPAN>
Is a calculated measure for each ranch/cycle combination the right path of thinking? -> could I =CALCULATE (SUM(tbl_expenses), ranch=112233,dates= BETWEEN 1/1/13 AND 6/30/13, etc. ) or this wouldn’t work? I have a table that document the start and stop date for a ranch - is there a lookup feature in DAX to refer to join ranchNumber and retrieve such values? Or am I thinking about this all wrong? </SPAN>