need to know which formula to use

[SADI]

i am using below formula to calculate the valid and invalid parameters. i want to calculate that if  column (tblpremierlabor[CustomTagName]="IMT" IMT value then if column is (tblpremierlabor[IMT Tag Validation]<=(tblpremierlabor[LaborDescription - Copy.1] then it should say false and true if this is not matching this criteria.

imt test = IF(tblpremierlabor[CustomTagName]="IMT",(tblpremierlabor[IMT Tag Validation]<=(tblpremierlabor[LaborDescription - Copy.1],true,false)))

[v-lili6-msft]

hi, @SADI

Do you want to calculate it in edit querie or data model by dax?

If you just want to add a calculate column

imt test =
IF (
    tblpremierlabor[CustomTagName] = "IMT",
    IF (
        tblpremierlabor[IMT Tag Validation]
            <= tblpremierlabor[LaborDescription - Copy.1],
        TRUE (),
        FALSE ()
    )
)

If not your case, Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

Best Regards,

Lin

[AlB]

Hi @SADI

It's difficult to understand what you need from that description. Maybe you could try to explain it with an example or with something like: 

IF Condition1

     then {

             IF Condition2

                     then

                           result= A

                     else

                           result=B

             }

       else{

             result=C

             }          

My guess from what you describe:

imt test =
IF (
    tblpremierlabor[CustomTagName] = "IMT" && tblpremierlabor[IMT Tag Validation] <= tblpremierlabor[LaborDescription - Copy.1],
    TRUE (),
    FALSE ()
)

[SADI]

Hello AIB,

As requested, Please find below clarification. If condition one matches then condition 2 need to execute after that result should be in true or false.

I tried the formula mentioned by you but it is giving error “DAX comparison operations do not support comparing values of type number with value of type text. “

IF Condition1

     then {

             IF Condition2

                     then

                           result= A

                     else

                           result=B}          

Regards

Saurabh

[v-lili6-msft]

hi, @SADI

 tblpremierlabor[IMT Tag Validation] <= tblpremierlabor[LaborDescription - Copy.1]

 tblpremierlabor[IMT Tag Validation] should be text format, tblpremierlabor[LaborDescription - Copy.1] should be numerical format,

So they couldn't be compared.  You should keep them be same format or create a mapping column/ table for text format.

For example: we couldn't compare "A" to 3, but if "A" =5, we could get known that "A" will greater than 3.

please share a simple sample pbix file or some data sample and expected output. You can upload it to OneDrive and post the link here. Do mask sensitive data before uploading.

Best Regards,

Lin