Blank = No

hello Tesla8181 ,

 

yes, you can replace the blank with NO in Power Query.

 

you can do this by right clicking on the blank value and click the replace option then fill in with what you want to replace.

 

Hi Tesla8181 ,

 

I’d like to acknowledge the valuable input provided by the Idrissshatila . Their initial ideas were instrumental in guiding my approach. However, I noticed that further details were needed to fully understand the issue. 

 

You can do this in the Power Query editor by selecting the column containing the blank field, going to the Transform tab, and then clicking Replace Value. In the Replace Value dialogue box, leave the value field to be found blank and enter No in the Replace With field.

 

You can also create a calculated column in the data model that replaces the blank value with No. Use the following DAX formula:

Column = 
IF('Table (2)'[Name] = BLANK(),"no",'Table (2)'[Name])

 

If your Current Period does not refer to this, please clarify in a follow-up reply.

 

Best Regards,

Clara Gong

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.