what makes things so hard are the following rules:
If FA is an integer (a number), then SUM(AMOUNT) is $$$
If FA is a string (some words), then SUM(AMOUNT) is fte's (so it refers to people, and not $$$)
If VERSION = CCA, then SUM(AMOUNT) is refering to Actual numbers. IF VERSION is everything else, then SUM(AMOUNT) refers to Budget / Forecast / Rolling forecast / actuals from a different system / anything else but Actuals.
I need to calculate the 6 months Rolling Average for Actual $$$ (so, FA = a number & VERSION = CCA). In addition, the rolling average needs to be per FSI.
I do have a DATE calculated measure: DATE = date([fiscal_year],[fiscal_month],01)
I'm rather noob and don't understand DAX good enough yet to figure this one out. (so suggestions on where to learn DAX are also most welcome). Halp plz?
edit: Just made a calculated measure called CCA_$. would that help?