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.
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.
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 |
---|---|
112 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |