Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Calculations with multiple constraints

Hello, I'm a uni student doing a final project for my IS degree and have only been using PowerBI for a couple of months. I'd really appreciate some help to solve the following (Model attached)....
az38's avatar
az38
Community Champion
6 years ago

Hi Anonymous 

it's more clear but its still dificcult to make a full solution

maybe you should try to use ISINSCOPE function https://docs.microsoft.com/en-us/dax/isinscope-function-dax

smth like

Measure = SWITCH( TRUE(),
ISINSCOPE('WAC SUPP'[BOM Stock Code]),
SUM('WAC Cost Table'[WAC]),
SUM('Product'[StandartCost])
)

do not hesitate to give a kudo to useful posts and mark solutions as solution

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Thanks for your response.

The solution sums all WAC values for a particular Product, however the fact also depends on the date of the transaction.
Hence Cost at WAC will depend on
1. ProductID (if its inscope of the BOM Stockcodes)
2. Date of transaction (If its within certain Month and Year in WAC Table (Invoice date inscope of WAC Cost table MonthYear)