Test and Measure ( Switch function )

[tyan]

Hi, I tried to make above table in powerbi.

AD column is by measue : switch( trure(), AB>=7, "yes", "No"))
AE Column is by vlookup from other excel worksheet.  

My question is AD is a Measure, and AE is just pure column (TEXT). I would like to get AF Column, which is if both SIZE IN FULL & ON TIME are under YES situation than YES otherwise is NO.

I was wondering how could I write a dax function in BI simialar as I showed in Excel.   I can use 1 and 0 as my yes or no. but I still wondering if is still possible to keep YES/NO to have DIFOT. 

Thanks inadvance. 

[v-jayw-msft · Accepted solution]

Hi @tyan ,

If AD is a measure, then AF needs to be a measure too.

You could create a new measure for AE then create a measure for AF:

AF = 
var _AE = selectedvalue([AE])

Return
IF([AD] = "Yes"&&_AE = "Yes", "Yes", 0)

If you want a column, then you will need to convert AD as a column.

It looks like the formula you used to create AD measure could be directly converted to a calculated column.

Best Regards,

Jay

[amitchandak]

@tyan , for looupup , we have lookupvalue

Using the column name you can have

new column =

switch( trure(), [AB]>=7, "yes", "No")

new column =

If([Size in full] ="Yes" && [On Time] ="Yes",1,0)

refer 4 ways to copy data from one table to another
https://www.youtube.com/watch?v=Wu1mWxR23jU
https://www.youtube.com/watch?v=czNHt7UXIe8

[tyan]

@amitchandak thank you for that, but not sure how come my final step not working. 

[tyan]

@amitchandak  and i think the reason is new column, so i tried new meassure. but since my AE  is just a text download from excel. is it a meaure.  im not sure how to deal with it. could you give me any method or suggestion on this case?