Forum Discussion

Oros's avatar
Oros
Post Prodigy
3 years ago
Solved

If statements

Hello.   Does this issue need a conditional measure? Any idea is highly appreciated.  Thanks.   I have the following product table and customer table.   For some reasons, the price that a...
Need Help
  • Chew_WenJie's avatar
    Chew_WenJie
    3 years ago

    Hi Oros ,

    according to the sample table, I am able to get the correct table. 


    Do the same customer have different pricing level?

Oros's avatar
Oros
Post Prodigy
3 years ago

Hi Chew_WenJie ,

 

Thank you again for your reply.  Here is the actual error.  Please note that Customer_Price_Group and Sales_Code are both equivalent to PRICING LEVEL in the example above.  CustomerPricing table is equivalent to PRODUCT table.

 

Chew_WenJie's avatar
Chew_WenJie
Resolver III
3 years ago

Oh I see, understood. I think for the error of code above you need to change to create new column instead of measure. 

Below is the code for measure and column, you may choose which you want.

Create New Measure :

Measure = 
var pricinglevel = SELECTEDVALUE('Customer Table'[Pricing Level])
return
CALCULATE(SUM('Product Table'[Price]),'Product Table'[Pricing Level]=pricinglevel)

Create New Column : 

Pricing = CALCULATE(SUM('Product Table'[Price]),'Customer Table'[Pricing Level]=EARLIER('Product Table'[Pricing Level]))

 

Hope this can help you, you also can refer to the ryan_mayu solution