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 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

Anonymous's avatar
Anonymous
Not applicable
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
Helper V
6 years ago

Thank you so much. It works!