Solved: How to create calculated column BLANK

admin_xlsior · ‎01-23-2020

Hi guys,

as subject, if I want to add new column, all blank, is it possible ?

I tried to use Add Conditional Column, and use any field for the condition and both is BLANK() / '' / ""

all doesn;t give me what I need.

All I want is just a new column with blank, but not null

Thanks

MFelix · ‎01-23-2020

Hi @admin_xlsior ,

Assuming you are refering to the query editor just add a new custom column and use the formula "" need to be formatted as text.

Regards,

MFelix

Regards

Miguel Félix

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português

View solution in original post

amitchandak · ‎01-23-2020

Column 5 = blank()

!! Power BI 101 Interview questions !! !! Master Microsoft Fabric- 36 Videos !!
Microsoft Power BI Learning Resources, 2023 !!
Learn Power BI - Full Course with Dec-2022, with Window, Index, Offset, 100+ Topics !!
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !! Proud to be a Super User! !!