Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I am not able to get rid off this issue.
I have a column containings 0,1,2 and i need to construct another column giving the text "Completed" once the value is 2 and "NotCompleted"otherwise.
Al my formulas give me no value, I cannot find the error, can you help me?
The formula is
Column=IF(Table1[Value]=2,"Complete","NotComplete") whatever would be the Table1[Value]
See picture attached...
Solved! Go to Solution.
NEWS..
I've try to simply close and reopen the report and now it's works!
Hello @giroldoale ,
what is the data type of the column - TetsOPCompIDynamic?
It should work if it is set as whole number.
Hi, It's a "Whole Number"
Is it possible for you to share your pbix file, removing all the sensitive data?
NEWS..
I've try to simply close and reopen the report and now it's works!
@giroldoale - Can you tell me what is the data type of TestopCompIDDynamic column (Sorry for wrongly typing this column name) ? If it is Text so just update your DAX like below:
Column = IF(Table[TestopCompIDDynamic] = "2","Completed","Not Completed")
Hi, It's a "Whole Number"
Hi @giroldoale
Can you provide some sample data in a format we can copy (not a picture)? What is your current code, M code?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |