Forum Discussion

syasmin25's avatar
syasmin25
Helper V
6 years ago
Solved

IF (DAX)

Hello, 


I am very much new to DAX calculations and was wondering if you guys could help me out with this. I am attaching an example of what I am trying to replicate in Power BI here. In the attachments, I have a table with the price sold for products in one sheet (meaning a field in PowerBI) and the price that was estimated for sales in another table. The column "Price_to_be_considered" (in table1) shows that if the price at which the product has been sold is less than the price at which it was estimated to be sold then we will take the lower one. However, if not then we the estimated price. I have been trying to implement this into Power BI between two tables and my DAX if statement is not working. 


Any assistance appreciated.

 


General Comment
Need Help
Show and Tell
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi syasmin25,

    You can create one measure as below:

    salaryR = var a=max('Table_2'[ID])
    var b=CALCULATE(max('Table_1'[Quantity]),'Table_1'[ID]=a)
    return if([Quantity_Sold]>b,"Yes","No")
     

    Best Regards

    Rena

8 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    6 years ago

    Assumed first table as price second as estimated

    Create a new column in price

    t_estimated1 = 
var _Eprice =minx(filter(estimated,price[id]=estimated[id]),estimated[estimated sales price])
return
if(price[price sold] < _Eprice,price[price sold],_Eprice)

    Change minx to maxx or < to > as per need

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi syasmin25,

    First, please make sure there is one relationship be created with field “ID” between your sales table and estimate table. Then create one calculated column on estimated table as below:

    1. Create relationship between 2 tables   

    2. Create one calculated column with formula:

    Price_to_be_considered =

    var a=CALCULATE(min('Product Sold'[Price_Sold]),filter('Product Sold','Product Sold'[ID]='Estimated sales'[ID]))

    var b=if(a<'Estimated sales'[Estimated Sales Price],a,'Estimated sales'[Estimated Sales Price]) return b

    Best Regards

    Rena