Forum Discussion

ak77's avatar
ak77
Post Patron
2 years ago

blank value for a table column

Hi All,

 

i need to add a blank value to below table column portfolio name at power bi side.. whats the best way to do this. please let me know

 

 

Need Help
Show and Tell

2 Replies

  • sevenhills's avatar
    sevenhills
    Super User
    2 years ago

    You did not mention whether you want to do in PQ or DAX.

     

    If it is in PQ, then use Table.InsertRows

    https://learn.microsoft.com/en-us/powerquery-m/table-insertrows

     

    If it is in DAX, create new table in the Modeling tab with blank row (Same as your existing table)

    You can only create new table and cannot append rows to the existing table as per my knowledge.
    Use ROW DAX function

    Table 2 = UNION ( 'Table', Row("Col1", BLANK()))
     
    Hope it helps!
  • Ritaf1983's avatar
    Ritaf1983
    Super User
    2 years ago

    Hi ak77 

    Add a table with 2 rows: one empty, second with some value ( because there is no option to combine with an empty table)

    2. Append origin table  with new table :

     

    3 filter out null ( the value that we added as unnecessary)

    4. Switch offloading to model the table that we added :

    Result:

    My personal recommendation instead of blank use some value like "others" 

    PBIX is attached 

    If this post helps, then please consider Accepting it as the solution to help the other

    members find it more quickly