Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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!
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
111 | |
96 | |
90 | |
79 | |
67 |
User | Count |
---|---|
157 | |
125 | |
116 | |
111 | |
95 |