Creating calculated values

[Crawfom]

I have two separate data sources - Fcast Price & Fcast units.

I want to create a chart showing the forecast income per week - which should be an easy to calculate price x units

I imagine that this is done through a 'calculated column' rather than a 'measure' as I want to drill down into the data

I have tried many DAX combinations but the numbers are never right or there are errors

[raji_n]

How arr you linking the tables, is it by product already?

check for aggregations if you are using a calculated column on your visual and also if your total are wrong then use SUMX to fix it while using the calculation on a table. @Crawfom 

[miTutorials]

Check out this short tutorial - let me know if this does not help!

Multiply 2 columns from 2 different tables in PowerBI using DAX | MiTutorials (youtube.com)

[PijushRoy]

Hi @Crawfom 

I think Price in Fcast Price table and unit is Fcast units table
What is the relationship between two table
Customer wise product price different or same i.e. Product A price is same for A, B, C, D customer?