Forum Discussion
Failing to make a relationship work
Good morning, I have a Fact table – Electricity Consumption - and a dimension table – Greenhouse Gas Emissions Conversion Factors by year. For a given year (or any month within it), I want to multip...
amitchandak
Super User
Super UserDJBrennan , Not very clear. You can have new column Consumption table
maxx(filter(conversion,conversion[year]= year(Consumption[Date])),conversion[conversion])
Hi,
Sorry that I wasn't clear enough but, as a result (all my fault) your solution is also not clear.
Here is my model view.
Sorry, I pressed enter too soon.... The emission factor in Emissions Factors is column Value and the consumption (confusingly and I will change this) in HHData is also "Value"