Get monthly price froma separate table

mapet — Mon, 27 Dec 2021 15:35:16 GMT

Dears,

I have two tables:

1. Total Hourly Cons (it contain hourly energy consumtion data)

2. Energy Price (it contain monthly energy price):

The scope is to add a colum in the first table that contain the price for the coresponding set of month & year, based o matching colums "date" of the first table and "month" of the second table. An many to one relationship betwen "Date" and "Month" is already established.

I've already had a try with

Column = RELATED(EnergyPrice[Price])

but it is only returning values for fixed dates (01.01.2020).
Any advice?

Later edit:

I've added in the first table an "start of month" column" and now the

Column = RELATED(EnergyPrice[Price])

is providing what i need.

Is there any other sollution?

Best regards.

Re: Get monthly price froma separate table

amitchandak — Mon, 27 Dec 2021 15:44:09 GMT

mapet , month seem to be using start date of the month

a new column in table one

maxx(filter(Table2, eomonth(Table2[Month],0) = eomonth(table1[Date],0)) , Table2[Price])

topic Get monthly price froma separate table in DAX Commands and Tips

Get monthly price froma separate table

Re: Get monthly price froma separate table