Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Solved! Go to Solution.
Hi @Anonymous ,
Try:
Replace with Unknown =
VAR _comp_code = MAX('REP EMPLOYEE_DAILY'[COMP_CD_TXT])
RETURN
IF(_comp_code="", "Unknown", _comp_code)
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Try IF ( TEXT, TEXT1, 0 )
or
Try IF ( ISBLANK(TEXT), TEXT1, 0 )
I hope this helps
@Anonymous , this didn't help. The blank value is coming while combining both the tables. There is no blank value in the single table. I wanted to fill the blank dynamically. not in the table.
Perhaps solve blanks in power query?
Proud to be a Super User!
Awesome Keyboard Shortcusts in Power BI, thumbs up if you like the article
My Community Blog Articles (check them out!)
My Blog - Power M code to automatically detect column types -
How to create test data using DAX!
Hi @Anonymous ,
Try:
Replace with Unknown =
VAR _comp_code = MAX('REP EMPLOYEE_DAILY'[COMP_CD_TXT])
RETURN
IF(_comp_code="", "Unknown", _comp_code)
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, were you able to find the solution to this?
Hi,
Did you get the solution for this blank. Please share once.
@Anonymous , You can do in a column, not in the measure in this case
new COMP_CD_TXT = coalesce([COMP_CD_TXT], "Unknown")
@amitchandak , thanks for quick reply.
But in the table, there is no blank value exists. While joining both the tables and creating the visuals from both the tables, the blank value is coming.