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.
Hello,
I am currently trying to replace a (blank) field with the text "Machine Check not Carried Out". The column itself is also in text format.
However, I can't seem to find the correct measure:
Solved! Go to Solution.
Hi, @kelly008
Try this
MKMachineBlank =
var CurrentItem = SELECTEDVALUE('Preventative Maintenance Log'[MaintenanceRequired2])
return IF( ISBLANK(CurrentItem )||CurrentItem = "", "Machine Check Not Carried Out", CurrentItem)
HI @kelly008 ,
What is the datatype of the column MaintenanceRequired2 in your table?
Is MaintenanceRequired2 a column in your table or measure?
If it is a column and is of text datatype, then use the following DAX expression:
MKMachineBlank =
IF (
ISBLANK ( yourTable[MaintenanceRequired2] ) = TRUE(),
"Machine Check Not Carried Out",
yourTable[MaintenanceRequired2]
)
In the above DAX expression just replace yourTable with the table name you have at your end.
Hi, thanks for replying.
I'm getting this error after using the measure you suggested:
I'm guessing this is becuase I didnt share the table name? Please see below:
Again, thank you for replying.
Hi, @kelly008
try this:
MKMachineBlank = IF( ISBLANK('MaintenanceRequired2') || 'MaintenanceRequired2' = "", "Machine Check Not Carried Out", 'MaintenanceRequired2')
Hi, thanks for replying, sorry I may not have included all of the relavent information.
I'm currently getting this error after using the measure you suggested:
I'm guessing this is becuase I didnt include the table that the column is coming from? This is the table alongside the column and the measure you suggested:
Again, thank you for replying.
Hi, @kelly008
Try this
MKMachineBlank =
var CurrentItem = SELECTEDVALUE('Preventative Maintenance Log'[MaintenanceRequired2])
return IF( ISBLANK(CurrentItem )||CurrentItem = "", "Machine Check Not Carried Out", CurrentItem)
Thats it! Thank you!
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 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |