Delighted to join the forum. May I ask for some assistance, please?
My scenario represents a “green energy” initiative. I have a major fact table “AllEnergy” that contains details of gas and electricity budget, spend and use month by month for 2018 and 2019. I have a scenario that allows me to distinguish between each of them, Electricity and Gas. Relationships are between Date in Calendar and Date in AllEnergy. You can see my measures and that all seems to work.
There are two other tables, GasGHG and ElecGHG each of which contains annual conversion factors allowing usage (in kWh) to be converted into whatever. In reality, these tables are identical and could be merged with a new column simply to distinguish gas from electricity. Should I do that?
I can link each of these with Calendar by Date and Page 2 shows that that relationship works.
What I need to is to create a measure that will multiply US (Gas example here) (US = CALCULATE(sum(AllFuel_2[Value]), filter(AllFuel_2,AllFuel_2[Scenario]=“Use”)))
by a category factor, say, “Tonnes KG N20” to produce the monthly, annual and PY “Total Tonnes N20”. I will, in fact,SERC DD Alternative for Enterprise DNA.pbix (358.1 KB) need to multiply US by each category in the GasGHG table.
Could you take a look and offer some advice, please?. My major issue is to make the link between US and the GHGGas Table. I’m thinking of inheritance via Calendar (?). There is no natural relationship.
PBIX is attached