asking help
2 Topics
Dax formula for matching string values between different columns for conditional formatting purposes
Hello Community, I am trying to dax the following logic to be able to use it as a conditional format on a matrix table " Project Column" under the below logic. So the logic says if the project mentioned is tagged to any of the projects subtypes give me a 0 and if not than 1. Here we have 3 projects with their assigned subtypes and no subtype of another project should be tagged to any to other project. WhenI created the below dax, it looks correct but it is not working and giving me an error when I try to set it to the field "projects" as conditional format so not sure if it is working or even daxed right. Any help and guidance would be Super! Improper Program Tagging - CF= MAXX('Table1', IF('Table1' [Project]= "Creativity" && 'Table1' [Project Subtype] IN {"ABCD","Crafts","CDO", "PR", "MF 6"}, 0,1) || IF('Table1' [Project]= Toys" && 'Table1' [Project Subtype] = “Lego",0,1) || IF('Table1' [Project]="Online Gaming" && 'Table1' [Project Subtype]= "Avengers",0,1))Solved1.8KViews0likes6Comments
Creating custom column with Multiple condition on Column
Hi All, I have a table containing the list of multiple items and values like below Item Name Value Kp123_K1 29.35 FK569_K1 11.5 Kp123_K2 30.25 FK569_K2 13.11 Kp123_K3 26.56 FK569_K3 12.00 In the new column, I should get if (item name(FK569_K1)<11.9) then item name(Kp123_K1 )* 24 if the condition is satisfied value will return( Ex. 29.35* 24) else false should be return. Can any one help me the dax formula for this to get new custom column Thank you for the helpSolved786Views0likes3Comments