Data on Date Range and Customer

Anonymous

Implement the below DAX and let me know if this is what you're looking for?

Create a new column applying the below DAX.

Price=
         CALCULATE( AVERAGE( PriceListtbl[Price] ),
                              FILTER( PriceListtbl,
                                          PriceListtbl[FromDate] <= ( transactiontbl[Date] )
                                          && PriceListtbl[ToDate] >= ( transactiontbl[Date] )
                                          && PriceListtbl[Customer] = ( transactiontbl[Customer] )
                                          )
                            )

Then taking it a step further to work out the Amount * Price per Customer, ignoring the date (although the Price is reflected by Date period in the first calculation) - see below:

Create a new table apply the below DAX:

tPRICE =
          GROUPBY( transactiontbl, transactiontbl[Customer],
                           "PRICEPRICE", SUMX( CURRENTGROUP(), transactiontbl[cPrice] * transactiontbl[Amount] )
                          )

Note: you can rename the column/table to anything you want.