Forum Discussion
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 -...
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]) < -50var c = a && bvar d = IF(c,MAX('Sheet1 (2)'[Quantity]), 0)return dRegards,
Ashfiya
--------------------------------------------------------------------------------------------------------------------------
Did I help you today? Please mark my post as a solution and hit the Kudos button.
Do you want to create a new column based on that condition?
No I do not want a new column as the data involved comes from 2 different tables in my data sources.