Creating calculated values

Question

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

pijushroy · Answer

Hi&nbsp;Crawfom&nbsp;I think Price in&nbsp;Fcast Price table and unit is Fcast units tableWhat is the relationship between two tableCustomer wise product price different or same i.e. Product A price is same for A, B, C, D customer?

mitutorials · Answer

Check out this short tutorial - let me know if this does not help!
&nbsp;
Multiply 2 columns from 2 different tables in PowerBI using DAX | MiTutorials (youtube.com)

raji_n · Answer

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

Forum Discussion

Creating calculated values

3 Replies

Related content

DAX for calculating retroactive values

Need help to create Calculation in DAX

PowerBI - Matrix table, hide values used only for a visual calculation

How can I create a calculator that pulls values from two table visuals?

Create calculated row