Forum Discussion

syasmin25's avatar
syasmin25
Icon for Helper V rankHelper 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 attach...
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

syasmin25's avatar
syasmin25
Icon for Helper V rankHelper V
6 years ago

Thank you so much for your help. I apologize for the inconvenience but I forgot to mention that the "Estimated Sales Price" is a measure which I have turned into the column in Power BI. However, even then it does not seem to work.