Forum Discussion

rpinxt's avatar
rpinxt
Solution Sage
3 years ago
Solved

If function on dataset

I have this data set: In this "Flow" comes from an excel file and the rest from 1 other data source.   Now I want to do an excel like funtion like:   If 'Flow' = "Reworked" then   TRUE  -...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    rpinxt ,
    If the two tables are related to each other this will work.

     

    Measure =
    Var a = MAX(Sheet1[Flow]) = "Reworked"
    var b = MAX(Sheet1[Amt LC]) < -50
    var c = a && b
    var d = IF(c,MAX('Sheet1 (2)'[Quantity]), 0)
    return d

     

    Regards,

    Ashfiya

    --------------------------------------------------------------------------------------------------------------------------

    Did I help you today? Please mark my post as a solution and hit the Kudos button.

     

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi rpinxt ,
I tried this measure as per my understanding. [TRUE  - If  ('Amt LC' > -50 ; 'Quantity' ; 0) ] I did not understand the 2nd condition for Quantity. Please check the below measure.

Measure =
Var a = Not(MAX(Sheet1[Flow])) = "Reworked"
var b = MAX(Sheet1[Amt LC]) > -50
var c = a && b
return if(c, "0","(true value)")

 

Regards,

Ashfiya

--------------------------------------------------------------------------------------------------------------------------

Did I help you today? Please mark my post as a solution and hit the Kudos button.

 

rpinxt's avatar
rpinxt
Solution Sage
3 years ago

Ok this looks like it could work but my "Flow" and my "Quantity" come from 2 different tables.

Here you have them both in 'Sheet1'.

I think that is were my problem is.